topic Re: Need help in set analysis in QlikView

Need help in set analysis

Mon, 05 Aug 2013 09:39:47 GMT

Hi,

as I have two fields are first one is Year and next one is status.

Year contains 2012 and 2013 and the status contains A,B,C,1

as I need a expression that 2012 and excluded of A, so I tried a expression as in the below, but its not working, could you please anyone correct me.

=Sum({1<Year={$(PY)} - Status="{$('A')}"}>}Sales))

Regards

Chriss

tresB — Mon, 05 Aug 2013 09:45:01 GMT

Exclude 2012 and A ?

Try this:

Sum({<Year={*}-{2012}, Status={*}-{'A'}>} Sales) // assuming that you want this irrespective of selection.

Sum({<Year - ={2012}, Status - ={'A'}>} Sales) // if you want to consider the selection

MayilVahanan — Mon, 05 Aug 2013 09:46:37 GMT

Try like this

= Sum({<Year = {$(PY)} , Status -= {'A'}>} Sales)

Hope it helps

Mon, 05 Aug 2013 09:54:08 GMT

Hi,

thanks for your reply.. as I need to select the Year and not equal of Status 'A' but I done it through your example...

Thanks a lot