topic Re: Using Set Analysis for 2 Fields in QlikView

Using Set Analysis for 2 Fields

microwin88x — Tue, 25 Mar 2014 19:04:53 GMT

Hello!

I have a line chart with the following expression:

COUNT ({$<ID_DATE#={">=$(='$(vDateFrom')<=$(='$(vDateTo)')"}>} DISTINCT TD_ENTRY_ID)

Where it counts # Tasks in my app for a Date range from a calendar.

That works ok, but now I need to include another filter for that set analysis expression:

CATEGORY should be equal to 'Payment'.

How could I do that, in order to consider the filter for ID_DATE and then also the CATEGORY filter?

Thank you!!!

jerem1234 — Tue, 25 Mar 2014 19:06:42 GMT

separate it with a comma in the set analysis like:

COUNT ({$<ID_DATE#={">=$(='$(vDateFrom')<=$(='$(vDateTo)')"}, CATEGORY = {'Payment'}>} DISTINCT TD_ENTRY_ID)

Hope this helps!

microwin88x — Tue, 25 Mar 2014 19:12:26 GMT

Excelent! It worked! Thanks!