Hi Friends I have a sample dataset like below I want to retrieve those customers whose Promot Sales Value > 0 and Normal sales Value = 0 . How to write query in qliksense??

[#1]

Hi Friends I have a sample dataset like below I want to retrieve those customers whose Promot SalesValue > 0 and Normal Sales Value = 0 . How to write query in qliksense??

Customer	SellType	SalesValue
XG970201	NORMAL	0
XE355501	PROMOT	1453
XE711301	NORMAL	0
XE355501	NORMAL	0
XF970201	PROMOT	0
XE530601	NORMAL	0
XE653901	NORMAL	0
XE653901	PROMOT	108756

Thanks & Regards,

Bibhuti

[ahmar811]

Try this in load Script

load

Customer,

SellType,

SalesValue

from Table where (SellType='NORMAL' AND SalesValue=0) OR (SellType='PROMOT' AND SalesValue>0);

hope this help you

Regards

Ahmar Ansari

[#3]

Thanks Mr Ahmad for your Response,

Can we write this query as Dimension axis while visualization from above dataset??

"Customers whose SellType is PRMOT then SalesValue > 0 and for those customers if SellType is NORMAL then SalesValue == 0"

Thanks,

Bibhuti

[ahmar811]

try this Expression on Dimension

=if((SellType='PROMOT' and SalesValue>0) OR (SellType='NORMAL' and SalesValue=0),Customer)

Thanks & Regards

Ahmar Ansari

[#5]

Thanks All for your valuable response .. I resolved the issue..

Thanks,

Bibhuti