topic Re: Chart with different Dimensions in QlikView

Chart with different Dimensions

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

Hi,

I have a chart with sum(sales) as expression for ex and i have 3 buttons to toggle dimensions for that chart in between 3 different dimensions.

That means, when i select button 1, it should show chart with dimension1 & sum(sales)

when i select button 2, it should show chart with dimension2 & sum(sales)

when i select button 3, it should show chart with dimension3 & sum(sales)

how to get it ?

Re: Chart with different Dimensions

sunny_talwar — Tue, 18 Oct 2016 09:58:49 GMT

What exactly is the issue you are running into? Do you have a sample where we can help you resolve the issue?

Re: Chart with different Dimensions

lakshmikandh — Tue, 18 Oct 2016 10:02:18 GMT

Using qsVariable extension you can achieve this, Please have a look at this article about cyclic group in Qliksense

Makes Sense to go round in circles

This will help you in implementing the above mentioned case.

Re: Chart with different Dimensions

mohan2391 — Tue, 18 Oct 2016 10:03:09 GMT

In the above pic, when i click on y-o-y, the chart should display data for dimension field year,

when i click on q-o-q, the chart should display data for dimension field quarter,

when i click on m-o-m, the chart should display data for dimension field month,

Re: Chart with different Dimensions

vcanale — Tue, 18 Oct 2016 10:09:37 GMT

Hi,
What about to set Variables for the buttons and use conditions for the Chart expressions?

Can you send a sample?

Re: Chart with different Dimensions

Anonymous — Tue, 18 Oct 2016 10:16:37 GMT

Hi,

Does the attached help your requirement to change the dimensions of your chart?

Re: Chart with different Dimensions

deepakkrish — Tue, 18 Oct 2016 10:26:56 GMT

Hi Mohan

First you have to create 3 seperate charts with which dimensions and expression

you want,

Secondly add that charts into container.

Next go to settings --> variable overview and create a variable name vShowChart=0,

After Creating the variable, select chart 1 properties go to Layout --> select the Show Conditional and write expression like vShowChart=1 click apply and OK,

Make the same changes like chart 2 & chart 3 expression like a vShowChart=2 & vShowChart=3.

Next create 3 seperate buttons , go to button 1 properties --> Action -->select External --> click Set variable

give variable name= vShowChart and Value =1.

In button 2 properties give variable name= vShowChart and Value =2. and

button 3 properties give variable name= vShowChart and Value =3.

Click apply and OK.

Now if u select the button 1 it will shows chart 1 with chart 1 dimensions , same like others too

Regards

Deepak

Re: Chart with different Dimensions

Anil_Babu_Samineni — Tue, 18 Oct 2016 10:29:20 GMT

This scenario, Good approach could be Sample provider

Re: Chart with different Dimensions

mohan2391 — Tue, 18 Oct 2016 10:35:57 GMT

Dimension needs to change depend on the selection and expressions still same.

I tried by setting variables on buttons and applied those variable conditions in "Enable conditional" for those dimensions

Re: Chart with different Dimensions

vcanale — Tue, 18 Oct 2016 10:40:48 GMT

"Dimension needs to change depend on the selection and expressions still same"

So you can create 3 different Charts with different Dimensions and Expressions and use the Conditional Layout to Hide/Show the Chart depending on the selection

Re: Chart with different Dimensions

mohan2391 — Tue, 18 Oct 2016 10:44:39 GMT

The chart is showing like in the last pic, it is not changing according to the selections

Re: Chart with different Dimensions

mohan2391 — Tue, 18 Oct 2016 10:46:27 GMT

That I can do, but i need to apply the same logic for almost 20 charts. So, if i create separate charts, the number will increase to 60-80 charts that the client doesn't want..

Re: Chart with different Dimensions

vcanale — Tue, 18 Oct 2016 10:50:42 GMT

..what about the expression?
Do you have one only expression "sum(sales)" ?

Re: Chart with different Dimensions

antosraf — Tue, 18 Oct 2016 10:52:12 GMT

just use one variable for all 3 dimensions

variable=1

variable=2

variable=3

Re: Chart with different Dimensions

vcanale — Tue, 18 Oct 2016 11:28:38 GMT

ok.. so coming back to an unique chart.. you can apply the same condition on the expressions as for the dimensions, 3 dimensions and 3 expressions.. or if it's not strictly necessary to have buttons, instead to use buttons to select the metric (month/quarter/year), you can include the 3 dimensions in a cycle group and use the cycle group as unique dimension and 1 expression.

Re: Chart with different Dimensions

mohan2391 — Tue, 18 Oct 2016 13:29:16 GMT

Okay, thanks for suggestions.

Re: Chart with different Dimensions

wallerjc — Tue, 18 Oct 2016 14:53:52 GMT

I have created you an example to show.

Hope this helps.

Thanks,

james.

Re: Chart with different Dimensions

deepakkrish — Tue, 18 Oct 2016 17:24:48 GMT

You will surely get by using container object.

Try that,

Re: Chart with different Dimensions

Frank_Hartmann — Tue, 18 Oct 2016 20:25:38 GMT

have a look at the attached sample.

hope this helps

Re: Chart with different Dimensions

rupamjyotidas — Tue, 18 Oct 2016 20:31:33 GMT

You probably might have click all the text boxes, all the variables have become 1. Best to use one variable 'vDim'

and use them as 1, 2 or 3 for each dimension.

You have many replies also and examples. It would help you. Probably when you have solved the issue, close the discussion.