topic Re: AND operator in QlikView in QlikView

AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 05:28:53 GMT

Hello folk,

Please any one tell me how to use AND operator in QlikView Set Analysis.

-- Thanks and Regards,

Villyee Anderson

Re: AND operator in QlikView

tresB — Thu, 24 Jul 2014 05:50:13 GMT

'*' is used as AND (intersection) in set analysis. Like: =Sum({<First Set> * <Second Set>} Amt)

See : OR AND operators in set analysis

Re: AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 06:20:59 GMT

Hi thanks for your reply

I am using this expression but it didnt work,

=sum({<Year = {2013}> * <Year = {2014}>} Sales)

I want those managers Id who has sales from 2013 and 2014.

-- Thanks

Villyee

Re: AND operator in QlikView

its_anandrjs — Thu, 24 Jul 2014 06:24:47 GMT

Try like

=sum({<Year = { '2013' , '2014' }>} Sales)

=sum({<Year = { 2013 , 2014 }>} Sales)

If sales want from 2013 to 2014.

Re: AND operator in QlikView

tresB — Thu, 24 Jul 2014 06:26:15 GMT

So there has to be a reference of manager field. try with p() element, like:

=Sum({<Managers=p({1<Year={2013}>*<Year={2014}>} Managers)>}Sales)

Re: AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 06:39:47 GMT

Hi anand thanks for you answer,

but it didnt work, Coz i want that managers who did sale in both year, not either one of them.

-- Regarsd,

Villyee

Re: AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 06:41:00 GMT

Hi,

I tried it but its not working.

-- Thanks and Regards,

Villyee

Re: AND operator in QlikView

tresB — Thu, 24 Jul 2014 06:49:21 GMT

Could you post your sample qvw explaining expected output?

Re: AND operator in QlikView

rohan_mulay — Thu, 24 Jul 2014 06:56:56 GMT

Try dis. I think this can work .. if not try a bit modification .. m not sure abt this

=Only({<Sales=p({1<Year={2013}>*<Year={2014}>} Sales)>}ManagerID)

Re: Re: AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 06:58:43 GMT

Hi,

PFA Qvw application with dummy data,

In this i want only 101 and 104 Id's data cause it did sales in both year not single year.

-- Thanks and Regards,

Villyee

Re: Re: Re: AND operator in QlikView

tresB — Thu, 24 Jul 2014 07:06:58 GMT

=Sum({<Id=p({1<Year={2013}>})*p({1<Year={2014}>} Id)>}Sales)

PFA

Re: AND operator in QlikView

vanderson009 — Thu, 24 Jul 2014 07:10:30 GMT

Many thanks tresesco, now you apply p() at both side, so its working.... gr8

-- Regards,

Villyee