Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

How about using set analysis such as:

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

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

Creator
Creator

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

Creator
Creator

Thank you for ur set Analysis. It works.