Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Set Analysis Filter Combination ?

Dear Expert,

From the Pivot Table above, I want to filter the data in Unit = A and Month = Jan & Feb.

My expectation is the display should be like this

So, the Total of Jan should be 55, Feb should be 40, and Total of Unit A should be 80.

But, if I use set analysis like Sum({<Unit-={'A'}, Month-={'Jan','Feb'}>} Qty), the result becomes

(Unit A, as well as Jan & Feb, are missing)

Thank you.

1 Solution

Accepted Solutions

Try this.

Sum({<Unit -= {"a"}>+<Month -={"Jan","Feb"}>}Value)

Regards,

Kaushik Solanki

Regards,
Kaushik
6 Replies
MVP

Can you provide sample app here?

Try this.

Sum({<Unit -= {"a"}>+<Month -={"Jan","Feb"}>}Value)

Regards,

Kaushik Solanki

Regards,
Kaushik
Anonymous
Not applicable
Author

Yes. Herewith I attach the sample app.

Thank you.

Anonymous
Not applicable
Author

Thank you Kaushik. It works

Great.

Regards,

Kaushik Solanki

Regards,
Kaushik