topic Re: Displaying charts based on list box values selections in QlikView

Displaying charts based on list box values selections

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one list box in that having values are Sales, SalesR, SalesE, Region, RegionE, Central.

in the same i have Charts like Sales, SalesR, SalesE, Region, RegionE, Central.

if i select the Sales in the list box then select the Sales chart, if i select Sales, SalesR values then display the Sales, salesR charts if no selections from the list box then hide the charts.

if i select the sales and Central then display the Sales, Central charts.

if i select sales and salesR it will display First and Last chart, but if i select the sales and central it is showing First chart and last chart Reaming is showing empty. But i want to show one by one in without space.

Please Suggest me this scenario is Possible or not, if possible please suggest me how to achieve this scenario.

if possible please share me example.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Sun, 26 Jan 2020 10:11:36 GMT

Hi, I'm not sure of what you are trying but seems that you need to use contitional expression in expression tab of the chart and/or conditional show in design tab.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Sun, 26 Jan 2020 11:18:51 GMT

Hi,

Thanks for replay.

I have list box with 5 values and 5 charts. based on the selections charts will display. if no selection is there then display all charts.

i have used Max(Index(ListboxName,'Value)), it is working fine, but if values are having similar then it will display both charts.

for example values like sales, sales info, then if i click 'Sales info' then display the Sales chart and Sales info chart.

Please suggest me how to avoid this scenario.

And if i select first and last chart values in list box it is showing first and last chart and reaming is hide and empty space is coming, but i want to display charts one by one if any selections in list box.

if i select 3 rd and 4th it is i want to display first and second like that.

please suggest me this is possible or not, if possible please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Sun, 26 Jan 2020 12:10:39 GMT

Hi, similar values can be avoided using separators, ie:

Index(';'& Concat(ListboxField, ';') &';', ';Value;')) // the starting and ending semilcolor will help with similar values, one will be ';Sales;' and the other ';Sales Info;'.

Hope this helps, regards.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Mon, 27 Jan 2020 09:52:29 GMT

Hi,

Thanks very much for your replay.

it is very helpful.

Please suggest me below scenario is it possible or not.

in the above scenario list box having 5 values and 5 bar charts.

if i click Sales Value then it is showing Sales chart as first place, if i select Sales info values then display Sales info chart as second place.

if i select Sales info chart it is showing 2 position and first position is showing empty.

But if i select the Sales info it is showing first position. and if i select both Sales and Sales info both are showing first is sales chart and 2nd is Sales info chart.

Please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Mon, 27 Jan 2020 10:02:04 GMT

Hi, I dont0 get the difference between this two:

-if i select Sales info chart it is showing 2 position and first position is showing empty.

-But if i select the Sales info it is showing first position. and if i select both Sales and Sales info both are showing first is sales chart and 2nd is Sales info chart.

In any case you can have all 5 chars with all expressiones needed and use contional expression to select wich expression will show in each chart. ie. for second chart conditonal expression for 'Sales Info' can be:

If(Index(';'& Concat(ListboxField, ';') &';', ';Sales Value;') and Index(';'& Concat(ListboxField, ';') &';', ';Sales Info;'), 1, 0)

You won't really need all expresions in all charts but you'll see which ones are needed when you start to configure them.

Regards.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Mon, 27 Jan 2020 11:12:53 GMT

Hi ,

Thanks for replay.

My problem is display the charts potions is dynamically.

I have 5 charts and we can place it one besides/below the other but to display them dynamically on user selection.

please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Mon, 27 Jan 2020 11:20:06 GMT

Hi, it's the same as befor: you need to use contitional expression in expression tab of the chart and/or conditional show in design tab.

I attach a sample on how it can work. If this is not what you are looking for please upload a sample that shows your needs.

Regards.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Mon, 27 Jan 2020 12:22:24 GMT

Hi ,

Thanks for your supporting.

Please see the below attached Qvw.

Here having Measure likes Sales, Sales Info, Sales total, Sales value and 4 charts corresponding to the values.

if i select the sales it is showing Sales charts, in the same all charts are showing.

my Selection is Sales total it is having last position to display the chart, but my requirement is my selection is sales total then it is showing sales chart position it means it is showing first chart, in the same way what ever the selection is first it is showing first and next selection is showing next like that, and if i clear the selection it is showing as it is it means Sales chart is showing first, next Sales info like that.

Please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Mon, 27 Jan 2020 12:49:00 GMT

As said before all matters is palying with conditional expression and conditional shows.

If something fails you can adjust it.

Regards.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Tue, 28 Jan 2020 09:44:12 GMT

Hi Rubenmarin,

Thank you very much for your support.

i achieved my expected results and i am getting one more problem.

in the same way display in text boxes also, i have used below expression in text box but it not working.

Please suggest me based on selection text values change dynamically.

=if(Measures='Sales','Sales',if(Measures='Sales info','Sales info','Sales'))

and in the list box is added one more value that is 'All'.

if i select Sales and sales info it is showing Sales, chart and Sales info chart then if i select 'All' then display the all charts.

Please see the below Qvw.

Please Suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Tue, 28 Jan 2020 09:55:56 GMT

Hi, it won't work because Measuers will return Null() when there are more than one value selcted, thats why you need to use Index and Concat, to merge all diffrent values in a single string and look in that string the searched value

Once you have all expression conditions working as expected you can use the same conditions to selecte the text:

If([ContitionsForExpression1], 'TextExpression1',

If ([ContitionsForExpression2], 'TextExpression2',...)

For the 'All you only need to add the condion in the charts to show the expected expression.

Sample attached, I also emulated the second chart text using the concatenated if

Re: Displaying charts based on list box values selections

Lakshman_1031 — Wed, 29 Jan 2020 06:48:14 GMT

Hi Rubenmarin,

Thanks for your Support and your support is very great.

i did not achieve full requirement sorry for again asking for doubt.

Here i selected Sales info and Sales values, but not coming sales value.

Index(';'& Concat(Measures, ';') &';', ';Sales;')=0 and Index(';'& Concat(Measures, ';') &';', ';sales Info;')=0 and Index(';'& Concat(Measures, ';') &';', ';Sales value;')

like sales ->Sales info-> Sales values this way charts are showing properly.

But my selection like last value, Middle value, except first value, it is not coming charts properly and it is showing all expressions disabled.

Like this way Sales Info->Sales total this type of selections was not working properly.

i tried but i am not getting any solution.

in the same way list box having 10 values and 10 charts please suggest me how to achieve this scenario.

in first chart i have wrote below expression

Index(';'& Concat(Measures, ';') &';', ';Sales;')=0 and Index(';'& Concat(Measures, ';') &';', ';Sales info;')=0 and Index(';'& Concat(Measures, ';') &';', ';Sales values;')=0 and Index(';'& Concat(Measures, ';') &';', ';Sales total;')=0

and Index(';'& Concat(Measures, ';') &';', ';Sales Amount;')=0

first chart is working fine.

in second chart is

Index(';'& Concat(Measures, ';') &';', ';Sales;') and Index(';'& Concat(Measures, ';') &';', ';sales info;')=0 and Index(';'& Concat(measure, ';') &';', ';Sales value;')

this way i wrote. if my first selection is Sales then sales -> sales info or sales values is working.

if my first selection is Sales info -> sales total this way is not working.

Please Suggest me how to achieve this particular scenario.

Please suggest me how to achieve this type of scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Wed, 29 Jan 2020 08:00:31 GMT

Hi, new approach, this can be used for many charts, should be a clever way using parametrized variables but it will take a time to develop that I don't have now.

Just use the index that fits for each chart, check the attachment to understand.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Wed, 29 Jan 2020 12:22:45 GMT

Hi Rubenmarin,

Thanks for your replay.

I tried same way you mentioned in the QVW, But that is not working properly.

Please suggest me is there any way to achieve this scenario.

Thanks & Regards,

Lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Wed, 29 Jan 2020 12:33:25 GMT

I have already suggested you different ways to achive that scenario. Why is not working?

Re: Displaying charts based on list box values selections

rubenmarin — Mon, 03 Feb 2020 14:23:12 GMT

Hi Lakshman, are you still trying, can you tell me why the suggested approaches are not working?

Re: Displaying charts based on list box values selections

Lakshman_1031 — Tue, 04 Feb 2020 15:00:58 GMT

Hi Rubenmarin,

Thanks for your replay.

Exactly my requirement is i have one list box in that having 10 values and having 10 charts.

Dynamically showing and hide the charts based on the list box selections.

for example if i select the sales info from list box then display sales info chart as first chart and then 2nd selection is Sales Amount then showing Sales Amount as 2nd chart and if i select Sales as 3 rd selection then display 3rd chart as Sales chart like that all the selection.

if is select the Sales Info as first selection then display Sales info as first chart.

whatever if i select first value then will display first chart, and if i select 2nd value then will display 2nd chart like that every selection.

if i remove the any selection in the list box then it will adjust the charts.

in the same way display text box and showing current selection value in every chart.

i have tried previously you suggested way, But i am not getting exact result. if i take sales info as first selection then select sales as second selection then it is showing always first chart as sales and if i take 3 selection it won't display data .

Please suggest me is there any possibility to achieve this scenario.

Thanks & Regards,

lakshman

Re: Displaying charts based on list box values selections

rubenmarin — Wed, 05 Feb 2020 07:49:32 GMT

Hi, ok, I don't think there is a reliable way of keeping the order the user selects values, maybe you can create 10 variables from chart 1 to chart 10, using a drop-down selection for each of the charts.

I upload a sample with just 2 charts.

Re: Displaying charts based on list box values selections

Lakshman_1031 — Fri, 07 Feb 2020 06:04:23 GMT

Hi Rubenmarin,

Thanks for your replay.

It is very helpful.

Thanks & Regards,

Lakshman