Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
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()
if(
(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'.

Capture.PNG

 

Thank you - I appreciate any advice.

Labels (1)
  • SaaS

3 Replies
fldc2500
Partner - Contributor II
Partner - Contributor II

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.

johngouws
Partner - Specialist
Partner - Specialist
Author

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. 

Kellerassel
Contributor III
Contributor III

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