topic Re: selection filter ? in QlikView

selection filter ?

Fri, 17 Mar 2017 04:10:02 GMT

HI All,

If i select USA, I want to see Sum, Max, Min Expressions.....

If i select UK, I want to see Count, avg, Max Expressions.....

If i select Ireland, I want to see Count, avg, Min Expressions.....

If i didn't select any CustomerCountry I want see all the expressions...

Kindly help me on this..

Regards,

Helen

Re: selection filter ?

tresB — Fri, 17 Mar 2017 04:42:55 GMT

Enable expression conditional check box and use expression something like:

for count expression = WildMatch( Concat(DISTINCT CustomerCountry&'|'),'*UK'&'|*','*Ireland'&'|*')

PFA

Re: selection filter ?

Anonymous — Fri, 17 Mar 2017 04:46:40 GMT

Do you want the effect only for 3 countries?? or for all the countries in your list??

Try using conditional expressions.

table properties - expressions - click on expression - check conditional - and writhe condition like getfieldselections(country) = USA or getselectionscount(country) = 0 for sum, and similarly getfieldselections(country) = UK or getfieldselections(country) = IRELAND or getselectionscount(country) = 0 for count etc.

Think this will work but lets see if there is any better way.

Re: selection filter ?

pipuindia99 — Fri, 17 Mar 2017 11:19:40 GMT

Hi,

PFA,

It works for me as required.

Re: selection filter ?

pipuindia99 — Fri, 17 Mar 2017 12:16:56 GMT

sorry attached wrong file earlier, attached now the correct file.

Re: selection filter ?

sunny_talwar — Fri, 17 Mar 2017 12:19:45 GMT

Did you even try this?

Selection of Countries ?