topic Re: Pivot table Header in QlikView

Pivot table Header

agni_gold — Tue, 19 Jul 2016 05:38:55 GMT

Hi friends ,

I have explained everything in picture below mentioned.

Re: Pivot table Header

marcus_sommer — Tue, 19 Jul 2016 05:46:49 GMT

I think you will need to create these data: Generating Missing Data In QlikView.

- Marcus

Re: Pivot table Header

agni_gold — Tue, 19 Jul 2016 06:18:19 GMT

Thanks Marcus,

My Data model is so bulky , i don't want to go in data model , is there any thing to resolve this in expression ?

Re: Pivot table Header

Anil_Babu_Samineni — Tue, 19 Jul 2016 06:41:55 GMT

Can i know, What are you expecting from this image. Can you plz explain more to get this point

Re: Pivot table Header

agni_gold — Tue, 19 Jul 2016 06:45:37 GMT

Suppose , i have making some filter in dashboard, and for those filter , dimension value John is not coming , so john will not come at header , i need john should not gone , it should present at header and value should come as zero.

Re: Pivot table Header

marcus_sommer — Tue, 19 Jul 2016 07:05:17 GMT

Quite often this could be handled with a calculated dimension and some complex expressions. But to implement this is far away from easy, the performance will be quite poor and such calculated dimensions will have disadvantages by the usability - therefore the better way is most to solve it within the script by generating the missing data.

- Marcus