Is creating pivot table better option than creatin... - Qlik Community

varunreddy · ‎2016-09-02

Hi All,

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!

Thanks,

Varun Reddy. K

agomes1971 · ‎2016-09-02

Hi,

please see this

HTH

André Gomes

Is creating pivot table better option than creating it in the script as coumns with huge data set?