Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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"

Hi Friends,

CustomerSellTypeSalesValue
XG970201NORMAL0
XE355501PROMOT1453
XE711301NORMAL0
XE355501NORMAL0
XF970201PROMOT0
XE530601NORMAL0
XE653901NORMAL0
XE653901PROMOT108756

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

1 Reply
balrajahlawat
Esteemed Contributor

Re: 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"

I think you would be required two chart for same.

One chart would be showing SalesValue>0 & another would be showing SalesValue=0

Dimesnsion:  only({<SellType={'PRMOT'}>} Customer)  

Expression: If(SaleValue>0,sum(SalesValue))

Similarly for another condition...