Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show / hide column with condition in pivot table

Hi

I want to show my result same as Fig1 instead of Fig2

is there any solution?

Fig1:

Fig1.JPG

Fig2:

Fig2.JPG

i want to show Count_No , Only in 2012

and not shown in other years.

thank you

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Is this OK?

I'm sure it can be done with a ValuieList() dimension as well. Then you won't need the extra INLINE table.

Good luck,

Peter

View solution in original post

6 Replies
sunny_talwar

The only way I can think of is to create field in the script using group by statement and then using it in the pivot table as a dimension instead of an expression.

Best,

S

Not applicable
Author

hi

could you help me to do this?

I can't do it myself

thanks a lot

israrkhan
Specialist II
Specialist II

can you please share a sample document,

will be easy to help you...

sunny_talwar

I just realized that you already have count as a field name and also did not see the last part where you need the sum for only 2012. I am working with your qvw file to figure out a solution.

Best,

S

Not applicable
Author

I attached a sample file and data file(XLS) in post 1.

tnx

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Is this OK?

I'm sure it can be done with a ValuieList() dimension as well. Then you won't need the extra INLINE table.

Good luck,

Peter