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: 
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