Discussion Board for collaboration related to QlikView App Development.
I am going to get 1.5 billion rows with three fields (i.e.Name and Rule and Indicator).
Each Name can have 'n' number of rules.
My question is, if I show each rule as a Column name, will that decrease the number of rows?
If Yes, Is it better to do in the script or directly use pivot table and show in the front end. Which will have better performance?
Issue I think if we create each distinct Rule as a column name:
As the Rules can be 'n' number, we need to create them as a dimension and use calculated dimension.
Which will have better performance?
Thanks in advance!
Varun Reddy. K
please see this
QlikView Performance | Qlik Community
How qlikview can handle a billions of records?
Qlikview with RAM 700 GB, but still slow
load table 760 million rows
Was loading almost 500 Million records in QlikView Dashboard Table and got a message "Object out of ...