Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello folk,
Please any one tell me how to use AND operator in QlikView Set Analysis.
-- Thanks and Regards,
Villyee Anderson
'*' is used as AND (intersection) in set analysis. Like: =Sum({<First Set> * <Second Set>} Amt)
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
Try like
=sum({<Year = { '2013' , '2014' }>} Sales)
Or
=sum({<Year = { 2013 , 2014 }>} Sales)
If sales want from 2013 to 2014.
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)
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
Hi,
I tried it but its not working.
-- Thanks and Regards,
Villyee
Could you post your sample qvw explaining expected output?
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)
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