Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.