Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
newuser
Creator II
Creator II

Filtering Pivot Table Based On Measure

Hi,

In my pivot table, I have the following expression as my lowest-level dimension (Dim3) to filter Dim3 by measure >= 50.

Do I need to apply this filter by making my measures expressions in my pivot table? Asking because I'm noticing my Amt1 + Amt2 measures are still including all values.

Does this question make sense? I did try to search the forum for similar questions but didn't find this particular question online.

Dim3:

If(AGGR(SUM(Amt1)+SUM(Amt2), Dim1, Dim2, Dim3)< 50,NULL(),Dim3)

Measure1 - instead of below, should this be an expression similar to above?

Sum(Amt1)

Thanks

0 Replies