Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
Creator II
Creator II

How about using set analysis such as:

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

Highlighted

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

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

Thank you for ur set Analysis. It works.