Finally a QlikView designer course that covers basics to advance of QlikView dashboarding. This course surpasses all the expectations in terms of quality of the content. It starts with best practices of dashboarding and then dives into explaining each concept clearly with visual storytelling. I have been working in QlikView for many years and this […]
In SQL statements, it is very useful to use IN clause in the query to compare your value against the provided list of values . In SQL you can write a query such as Select ProductName,Revenue from Products where ProductName IN (‘Chairs’,’Tables’,’CrossArmChairs’); QlikView does not have IN operator instead QlikView provide match() function to achieve this functionality I […]
Role playing dimension is used when a dimension table is reused to join with a fact table more than once. A classic example of a role playing dimension can be a Time Dimension which joins with a Fact table. This Fact table contains OrderDate,ShipDate,ReceiveDate etc. To get these dates you will create just one table for TimeDim in […]
Recently at work, someone had a problem in assigning a consistent color to the dimension. For example, if a table consist of Products and Revenue then each Product should maintain a consistent color, irrespective of the selection. Suppose the table is as follows : A pie chart for the above table should maintain consistent colors for the Products i.e. BabyClothes should retain RGB(141,170,203),Sports […]
In QlikView, if the number of fields and field names of two or more tables are same then the tables are Concatenated into one table. It usually happens when you are loading tables from different datasources and don’t realize that field names and field numbers in different tables are same. After the dataload you expect to see two […]
I’m working as an S/W Tester.Your articles and tutorials (...)
Vinoth: We provide QlikView Training. This training will (...)
Excellent training by Chandraish. Highly knowledgeable. He (...)
hello iam vinothkumar from india.iam looking for qlikview (...)
It's a shame that there is not more flexibility about the (...)
US Office : +1 614 398 0454 ; 404 626 0379
: