topic Re: Set Analysis Filter Combination ? in QlikView

Set Analysis Filter Combination ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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)

Please help me to find the solution for this case.

Thank you.

MK_QSL — Fri, 30 Jun 2017 07:47:10 GMT

Can you provide sample app here?

kaushiknsolanki — Fri, 30 Jun 2017 07:49:36 GMT

Try this.

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

Regards,

Kaushik Solanki

Anonymous — Fri, 30 Jun 2017 07:54:53 GMT

Yes. Herewith I attach the sample app.

Thank you.

Anonymous — Fri, 30 Jun 2017 09:23:50 GMT

Thank you Kaushik. It works

kaushiknsolanki — Fri, 30 Jun 2017 09:40:04 GMT

Great.

Please mark a post which gave you the right answer as "Correct Answer"

Regards,

Kaushik Solanki

Anonymous — Fri, 30 Jun 2017 10:29:44 GMT

Great work Mr Kaushik.