Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to create a dynamic Range for bar chart

Hi all,

I have a question here:

When I added a reference line to a bar chart, if the value of the reference line is too high, it will shows as 1.

Refer screenshot below, Chart on the left.

MC.PNG

I managed to create a customized range by adding a minimum value into the range, chart on the right.

However, this range seems weird, normal range should looks like 0 to 600k, a rounded value instead of showing as decimal point.

Any idea how to create a dynamic range for this?

For example, when CHINA is selected, range should be 0 to 600k.

Subsequently when NEPAL is selected, range should be 0 to 600.

Refer sample qvf attached.

 

Thanks and regards,
Arthur Fong

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Create a variable(vRangeCeil) to store the equivalent length for the line value:
='1'&repeat(0,len(sum(Plan))-1)

This will return the number of tenths for each selection.
eg: for CHINA, plan value= 6000. This will return 1000.
       for NEPAL, plan value = 600. This will return 100.

On the range value, add in the variable created into the expression:
ceil(sum(Plan),$(vRangeCeil))

View solution in original post

1 Reply
Highlighted
Partner
Partner

Create a variable(vRangeCeil) to store the equivalent length for the line value:
='1'&repeat(0,len(sum(Plan))-1)

This will return the number of tenths for each selection.
eg: for CHINA, plan value= 6000. This will return 1000.
       for NEPAL, plan value = 600. This will return 100.

On the range value, add in the variable created into the expression:
ceil(sum(Plan),$(vRangeCeil))

View solution in original post