Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

varunreddy
Contributor III

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

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

Tags (1)
1 Reply
agomes1971
Valued Contributor II

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