Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Issue with set analysis expression

Hi,

I have a table chart in one of the dashboard, and data is as below:-

ProductCustomerInvoiceusage levelQty On Hand
xyz1Danielabcd0847Normal11
xyz1Danielabcd1454Normal11
xyz1Daniel---0

 

Now I have to colour code the measure column(Qty On Hand), based on the condition and codition is as below:-

I need to sum Qty on Hand for product / Customer and if the total is greater than the Level column

then it is Blue.Here the level  column is on the per  invoice line so we would need to AVG the value.

 

for ex:- if sum(Qty on Hand )> Level, it means  (2>1) so it should be blue

Plesae suggest, how to write expression for this.

Labels (1)
1 Reply
Highlighted
Partner
Partner

Try this:

=if( sum( TOTAL <Customer> [Qty on Hand] ) > only(level), Blue(), Red())

Plees ekskuse my Swenglish and or Norweglish spelling misstakes