Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

Pivot demension conditions

Hi, there. I have a sample question.

I just want to show a part of data in Pivot table.  Coditions is   Demension1 >= Today()-60, Demension2 <> 'A' und Demension2 <> 'B'.

Can u help me write that statemant? Thank you.

1 Solution

Accepted Solutions
sunny_talwar

You have all both these dimensions within your pivot chart? Also, what is your expression... it will be better to add them as set analysis rather than calculated dimension

Sum({<Dimension1 = {"$(='>=' & Date(Today() - 60))"}, Dimension2 -= {'A', 'B'}>}Measure)

View solution in original post

4 Replies
briancopple
Creator II
Creator II

How about using set analysis such as:

=sum({Demension1={">=$(=Date(Today()-60))"},[Demension2]-={'A','B'}>} Value)

sunny_talwar

You have all both these dimensions within your pivot chart? Also, what is your expression... it will be better to add them as set analysis rather than calculated dimension

Sum({<Dimension1 = {"$(='>=' & Date(Today() - 60))"}, Dimension2 -= {'A', 'B'}>}Measure)

tomcatxx
Creator
Creator
Author

Yes, that's right. Thank you very much. It works now.

tomcatxx
Creator
Creator
Author

Thank you for ur set Analysis. It works.