Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table chart in one of the dashboard, and data is as below:-
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.
=if( sum( TOTAL <Customer> [Qty on Hand] ) > only(level), Blue(), Red())