topic Re: Issue with field selection upon Set analysis in QlikView

Issue with field selection upon Set analysis

Fri, 29 Nov 2013 09:05:23 GMT

hi all,

I have the next set analysis expression:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA={"*"}-{''}>} SUBSCRIBER_COUNT)

but the problem I have is that when I want to make a selection on MA it doesn't work.

the condition not to sum the ones with empty MA is very important for the total. but makes a certain selection on this field not work.

does anyone have an idea how to solve this?

thanks,

Boris

salto — Fri, 29 Nov 2013 09:11:15 GMT

Hi,

in the load script, try to assign a value (Empty) to the empty MA fields. Then:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA={"*"}-{'Empty'}>} SUBSCRIBER_COUNT)

Hth.

tresB — Fri, 29 Nov 2013 09:23:54 GMT

Try with exclusion operator '-', like:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA -={''}>} SUBSCRIBER_COUNT)

Fri, 29 Nov 2013 09:57:02 GMT

Hey Boris..

It will work with the same expression .. it is not recating on selections

Because u specified * in the expression , represents all values ,

If u observe eventhough u are try same expression in text box also not react..

one more thing is it may not the key field ...

Regards,

koti