topic Re: Expression help in QlikView

Expression help

Mon, 31 Aug 2015 09:51:50 GMT

Hi guys Ive got an expresion related question.

I have this expresion:

if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr))

want to say only getselected count of registr when the operator of it is 'AAA'. (operator='AAA') How can I add that in this expresion, Im not getting my desired result. There can be more Registr selected, therefore it only has to do this for operator AAA.

I prefer set anlysis, but didnt get it to work.

Thanks!

Re: Expression help

sunny_talwar — Mon, 31 Aug 2015 10:01:10 GMT

May be this:

if(GetSelectedCount(Registr)=0,12,Count(DISTINCT {<operator = {'AAA'}>}Registr))

Re: Expression help

alexandros17 — Mon, 31 Aug 2015 10:02:13 GMT

If(Operator='AAA', if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr)), 0)

let me know

Re: Expression help

Mon, 31 Aug 2015 10:11:27 GMT

This doesnt work.

Re: Expression help

Mon, 31 Aug 2015 10:13:15 GMT

This one works, only if I have operator AAA selected. But if I have another one selected too it doesnt work anymore.

It should still work then, but it should still only get the selected count where the registr belongs to operator AAA. Is this possible?

Re: Expression help

sunny_talwar — Mon, 31 Aug 2015 10:15:03 GMT

Try this:

If(WildMatch(GetFieldSelections(Operator), '*AAA*'), if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr)), 0)

Re: Expression help

Mon, 31 Aug 2015 10:15:35 GMT

so something like:

if(GetSelectedCount(Registr WHERE operator= 'AAA')=0,12,GetSelectedCount(Registr WHERE operator= 'AAA')), 0)

^this doesnt work of course.

Re: Expression help

Mon, 31 Aug 2015 10:17:30 GMT

This doesnt work either. See my previous comment, it should behave like that. Can I?

Re: Expression help

jagan — Mon, 31 Aug 2015 10:19:57 GMT

HI,

Try like this

=If(Count({<operator= {'AAA'}, Registr ={$(=GetFieldSelections(Registr, ','))} >} Registr ) = 0, 12,

Count({<operator= {'AAA'}, Registr ={$(=GetFieldSelections(Registr, ','))} >} Registr ))

Hope this helps you.

Regards,

Jagan.

Re: Expression help

Mon, 31 Aug 2015 10:45:02 GMT

Correct! Thank you very much, would never found that by myself!