Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Pivot table Header

Hi friends ,

I have explained everything in picture below mentioned.

Test.jpg

5 Replies
marcus_sommer

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

- Marcus

agni_gold
Specialist III
Specialist III
Author

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 ?

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
agni_gold
Specialist III
Specialist III
Author

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.

marcus_sommer

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