Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
newuser
Contributor III
Contributor III

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