topic Re: Help me in displaying bars based on input value? in QlikView

Help me in displaying bars based on input value?

durgabhavani — Fri, 15 May 2015 09:53:33 GMT

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

Re: Help me in displaying bars based on input value?

Gysbert_Wassenaar — Fri, 15 May 2015 10:04:50 GMT

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

Re: Help me in displaying bars based on input value?

durgabhavani — Fri, 15 May 2015 10:12:16 GMT

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

Re: Help me in displaying bars based on input value?

Anonymous — Fri, 15 May 2015 10:14:34 GMT

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

Re: Help me in displaying bars based on input value?

Anonymous — Fri, 15 May 2015 10:20:31 GMT

Re: Help me in displaying bars based on input value?

manojkulkarni — Fri, 15 May 2015 10:25:11 GMT

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

Re: Help me in displaying bars based on input value?

durgabhavani — Fri, 15 May 2015 10:26:53 GMT

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

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

Re: Help me in displaying bars based on input value?

jagan — Fri, 15 May 2015 10:27:27 GMT

Try like this

Chart Properties -> Dimension Limits ->

Hi,

Re: Help me in displaying bars based on input value?

MarcoWedel — Fri, 15 May 2015 10:41:25 GMT

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:

hope this helps

regards

Marco

Re: Help me in displaying bars based on input value?

durgabhavani — Fri, 15 May 2015 10:50:05 GMT

Super Marco! Its working! Great Idea..

This is the output i want!

Re: Help me in displaying bars based on input value?

MarcoWedel — Fri, 15 May 2015 10:55:42 GMT

glad I could help

regards

Marco