topic Re: How to use conditional view with getfieldselections based on multiple selection in a list box in QlikView

How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 14:03:26 GMT

How can we create individual Pie Chart with each combination of Dimension and Measures selected from a list box?

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Anonymous — Fri, 17 Apr 2015 14:29:12 GMT

for dimensions you can use a variable and a listbox

e.g. I defined an Inline table

Dimension:

load * Inline [

Dimension

Dim1

Dim2

];

Next I define a varieble vDimension with the =GetFieldSelections(Dimension)

Now you Show a listbox with the field "Dimension"

In Cour Chart you define a calculated Dimension =$(vDimension)

With Measure I tried something similiar but could not succeed right now

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Anonymous — Fri, 17 Apr 2015 14:37:00 GMT

the same for measures

Measure:
load * Inline [
Measure
Val1
Val2
];

Variable vMeasure with =GetFieldSelections(Measure)

listbox with field Measure

Expression: sum($(vMeasure))

In my small test it worked well

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 14:38:40 GMT

Thank You Rudolf for your quick reply....tat works fine....jus one addition.

Attached a sample QVW....all I want to do is Display multiple charts based on the selection made in the list box....

eg:

Step1

If I select 'Item Code' from Available Dimension List Box and 'Amount of transactions' from Available Measures List Box it will show the respective Pie Chart

Step2

With above selection made,If I select 'Location Code' from Available Dimension List Box and 'Amount of transactions' from Available Measures List Box it will show second Pie Chart with respective selection made in the second step

Step3

With above 2 selection made,If I select 'Location Code' from Available Dimension List Box and '# of Transactions' from Available Measures List Box it will show third Pie Chart with respective selection made in the third step.

Ideally all the individual charts will have always one Dimension and one expression.

Any thoughts!!!

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Anonymous — Fri, 17 Apr 2015 14:44:58 GMT

for my understanding:

do you want 3 pie Charts in parallel all of them with own Dimension and measure?

if this is the case you Need 3 inline Dimension and measure tables

otherwise please clarify.

I donot see your attached sample qvw

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 14:50:49 GMT

Yes I need three Pie Charts....can we use conditional view based on the selection in the Dimension List box?

I dint get how we can do it from three inline loads,could you please throw some light?

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

awhitfield — Fri, 17 Apr 2015 14:56:27 GMT

Hi John,

have you https://community.qlik.com/docs/DOC-5404had a look at the following post on Ad-hoc Reporting?

Cheers

Andy

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 15:10:58 GMT

Yes Andrew....that is applicable to a single chart,here my challenge is to create individual pie charts with the selection made in the list box....each pie chart will have one dimension and one measure

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

awhitfield — Fri, 17 Apr 2015 15:21:48 GMT

Sounds do-able, but fiddly, I guess you are going to have to have create 9 separate charts one for each dimension / expression combo and use conditional shows everywhere!

Andy

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

awhitfield — Fri, 17 Apr 2015 15:23:23 GMT

See the Ad-hoc blog for how these are used

Andy

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Anonymous — Fri, 17 Apr 2015 15:25:33 GMT

maybe alternate states would it mke it easier. I didnot work with them yet

for your 3 pie Charts with 3 independant Dimension and measure you Need 3 inline table with 3 different fieldnames

Dim1:

load * Inline [

Dim1

Region

Product

];

Dim2:

load * inline [

Dim2

Region

Product

];

etc.

this should work. It might get better Solutions.

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 15:27:03 GMT

Yes...and tats where I am stuck....the getfieldselection is not working for multiple selection in the listbox

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

awhitfield — Fri, 17 Apr 2015 15:47:30 GMT

Hi John,

See attached, based on the ad hoc, just done for the company Dimension

Andy

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

Fri, 17 Apr 2015 16:18:01 GMT

Hi Andy,

That was really helpful,to make it more user friendly....can we use a conditional view for each chart?

Is there any function so that if the selection is made on just Company and Sum it will display only the respective chart and on next selection of Avg it pops up the second chart?

Re: How to use conditional view with getfieldselections based on multiple selection in a list box

awhitfield — Mon, 20 Apr 2015 08:13:28 GMT

Yes, you could do all that with conditional views! Happy playing