Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anirban_musib94
New Contributor

Sum with conditional Expr

Hi,

I want to create a Gauge in Qlik Dashboard showing total gross sales. I have five columns in the table: Sale ID , Qty, Unit Sales Price, unit Purchase Price & Net Gross.

I would like to show Total Gross when Unit Sales Price is higher than Unit sales price and I would also like to show Count of Sales ID when Unit SAles price is higher than Unit Purchase Price.( both custom measures).

Thank you

Anirban

Tags (2)
2 Replies
arvind_patil
Valued Contributor III

Re: Sum with conditional Expr

Hi Anirban,

Please provide sample data.

confuse at here: "Unit Sales Price is higher than Unit sales price"


Thanks,

Arvind Patil

kakani87
Contributor III

Re: Sum with conditional Expr

May be this ?

What i understood is if  Unit Sales Price is > Field?(Not mentioned) display Gross

-if(sum(Unit Sales Price) >  sum(Field?),sum(Gross))


- if( sum(Unit SAles price) > sum(Unit Purchase Price),count(distinct Sales ID))


Community Browser