Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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...