Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Partner - Specialist
Partner - Specialist

Qlik Sense - Representation - Indicator

Good morning.
I would like to know if it is possible to use the 'Representation - Indicator' to indicate if today's sales are greater or less than yesterdays?
I am able to achieve this by changing the number format by using 'chr(9660)&'#,##0')' or 'chr(9650)&'#,##0')' and then defining the text color expression to be red or green.

I think is should be simpler to use 'Representation - Indicator', but I am unable to get it defined correctly.
The below expression is what I am using.

if(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]) =0 and Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]) =0,
Num(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]),'#,##0'), //Color exp Black()
(Sum({<Date_Num={"$(=max(Date_Num-1))"}>} [#Qty]) > Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty])),
Num(Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]),chr(9660)&'#,##0'), //Color exp Green()
Num(Sum({<Date_Num={"$(=max(Date_Num))"}>} [#Qty]),chr(9650)&'#,##0') //Color exp Red()

If I use similar logic in the 'Representation - Indicator' it does not return correct arrow results.

I am able to get the 'Representation - Indicator' to work when I define a GP% upper and lower bands or where values are less that or greater than specified number. Maybe what I am trying to do is not for the 'Representation - Indicator'.



Thank you - I appreciate any advice.

Labels (1)
  • SaaS

3 Replies
Partner - Contributor
Partner - Contributor

I'm experiencing the same issue. I would love it to be able to use the indicator to compare to a period of time before the presented value.

It seems to me that the indicator, like you said, can only be specified with a given number instead of working like the background colour of a measure for example where it also takes the dimension you use into consideration when defining the colour.

I hope this is a functionality yet to come, otherwise I feel like this is a missed opportunity.

Partner - Specialist
Partner - Specialist

Good morning. 

Thank you for your reply. Because there was never any feedback, I thought I was the only person on the planet wanting to show this type of comparison as a indicator. 

I definitely believe having this functionality under the 'Representation - Indicator' functionality instead of having to write this type of expressions would be a better option. 

Contributor II
Contributor II

I need the exact same thing! Haven't found anything so far.