Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

is the are way to create drop down box to change dimesions for x axis

Hi All,

I need help for

changing dimension values for my app.

1.the bar chart contains two x axis and one y axis.
2.the drop downs should change dimesions

like drop down should have options like option1,option2,option3 which should change the among themselves.
dropdown2 should have optiona,optionb,optionc which should change among themselves.

I tried that but I am not able to sperate the options using alternate dimesions.
for example my alternative dimesion options are giving me option1,option2,option3,optiona,optionb,optionc.

Also how to add values on top of the bars.

Regards,
Vinayak

3 Replies
OmarBenSalem
Esteemed Contributor

Re: is the are way to create drop down box to change dimesions for x axis

Let me as you a question, you want a filter for example that contains 2 values:

Value 1 and Value 2 ;

if you select Value1 , you'll have in your bar chart 3 alternative dimensions option1,2 and3

if you select Value2 , you'll have in your bar chart 3 alternative dimensions optiona,b andc

is that so?

OmarBenSalem
Esteemed Contributor

Re: is the are way to create drop down box to change dimesions for x axis

If that is the case, do as follow :

1) Create an inline table as follow:

load * inline [

Option

Option 1

Option 2

];

2)

In your bar chart :

Dimension: (call it Dim 1)

if( Option = 'Option 1', YourDimension1, YourDimensionA)

Alternative dimension : (call it Dim 2)

if(Option='Option 1', YourDimension2,YourDimensionB')

Alternative dimension : (call it Dime 3)

if(Option='Option 1',YourDimension3,YourDimensionC')

Now, as a title , do as follow:

if( Option='Option 1', 'Dim 1 =YourDimension1 Dim2=YourDimension2 Dim3=YourDimension3' ,

'Dim 1 =YourDimensionA Dim2=YourDimensionB

Dim3=YourDimensionC)


to have the values on the bar, go to aspect, presentation :

Capture.PNG



Per analogy: I want to have Value 1 and Value 2 as options.

If I select value 1 I want to have 2 alternate dimension : Region and territory code

if I select Value 2 I want to have Year and english short name as alternative dimensions


1)

Capture.PNG

2) Dimension 1 : =if(Option='Value1',[OICA region],Year)

Capture.PNG

Dimension 2: =if(Option='Value1',[Territory code],[English short name])


Capture.PNG


Title:

=if(Option='Value1', 'Dimension 1 : Région ,Dimension 2 Territory code', 'Dimension 1: Année ,Dimension 2 english short name')

Capture.PNG



Result :

Capture.PNG

Capture.PNG




Capture.PNG



etc !

Hope this helps

Not applicable

Re: is the are way to create drop down box to change dimesions for x axis

HI Omar,

Thank you for your time. Actually I need to dimesions for x axis and each dimesion should have options to choose from

Like for x.Dimesion1->country,gender,profile for x.Dimesion2->a,b,c

so my dimesion should be like

count(id) which is my y axis |

                                             |_________________x.Dimesion2(a,b,c)____________________________________

                                             |

                                             |                                               |

                                             |                                              |

                                             |

                                             |______________________________________________

                                               x.Dimesion(country,gender,profile)

Regards,

Vinayak

Community Browser