Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help me in displaying bars based on input value?

Hi All,

I have one bar chart with one dimension "countyname" having 30 countries.

Now my challenge is to display number of countries in chart based on input value in chart.

How can I use "text in chart" in presentation tab to display particular number of countries.

ex: if i gave 10 as input value in chart then it will show 10 bars. suppose if i gave 5 as input then it will show 5 bars.

NOTE: All this need to be implement in chart itself. so i am planning to use text in chart option in presentation.

This is highly appreciated.

Thanks,

Durga

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Try like this

Chart Properties -> Dimension Limits ->

Dimension Limits.pngHi,

View solution in original post

10 Replies
Gysbert_Wassenaar

Charts don't have input boxes. What you can do is use an input box to set the value of a variable and use that variable in your chart on the Dimension Limits tab to limit the number of bars shown. See attached example


talk is cheap, supply exceeds demand
durgabhavani
Creator III
Creator III
Author

Thank you for your response Gysbert!

Dont mind! please share screenshots. I have no access to qvw's due to security reasons.

waiting for reply!

Thanks,

Durga

Anonymous
Not applicable

Hi Durga,

Actually Text in Chart is only for showing something in chart.

We can't take the value from this option.

We can only show the info in chart using this option.

So you can use Input Box/Slider for that functionality.

You can use a variable in input box and can set the value of that variable with any input value and then use that variable in Chart's Dimension Limit Property to limit the no of values shown in chart.

Thanks & Regards

Prince Anand

Anonymous
Not applicable

Dimension Limit.PNG

manojkulkarni
Partner - Specialist II
Partner - Specialist II

goto Chart Properties - Dimension Limit - Enable Restrict ... - Show Only - Largest Values..

durgabhavani
Creator III
Creator III
Author

Thanks Gysbert, anand for your suggestions. I am cleared for your inputs.

@ anand: Can i define variable as 0 by default.

jagan
Luminary Alumni
Luminary Alumni

Try like this

Chart Properties -> Dimension Limits ->

Dimension Limits.pngHi,

MarcoWedel

Hi,

using gwassenaar‌ solution, you could position the input box on top of the chart.

Unchecking the "show caption" and "use borders" options would seamlessly integrate the input box into the chart:

QlikCommunity_Thread_164162_Pic1.JPG

hope this helps

regards

Marco

durgabhavani
Creator III
Creator III
Author

Super Marco! Its working! Great Idea..

This is the output i want!