Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

1 Solution

Accepted Solutions
awhitfield
Esteemed Contributor

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

Hi John,

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

Andy

14 Replies
hrlinder
Honored Contributor

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

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

hrlinder
Honored Contributor

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

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

Not applicable

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

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!!!

hrlinder
Honored Contributor

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

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

Not applicable

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

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?

awhitfield
Esteemed Contributor

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

Hi John,

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

Cheers

Andy

Not applicable

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

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

awhitfield
Esteemed Contributor

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

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

awhitfield
Esteemed Contributor

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

See the Ad-hoc blog for how these are used

Andy

Community Browser