topic Re: 2 dimensions, 2 expressions each-cyclic group in QlikView

2 dimensions, 2 expressions each-cyclic group

rdsuperlike — Fri, 15 Jan 2016 23:15:11 GMT

I am trying to do grouping for 2 dimensions with 2 expressions each

eg:

Dim 1 + expressions 1 gives one result

Dim 2 + expression 2 gives second result.

But while grouping thorugh dimensions and expressions i see that two cyclic group has got created.

Group 1 = dim 1 and dim2

expression group = exp1 and exp2.

But when it gets displayed for the graph, I can see 4 combinations

dim 1, exp 1---correct

dim 2, exp 1--incorrect

dim 1, exp 2--incorrect

dim 2, exp 2--correct.

I just want 2 combinations from above 4 since the other two are incorrect. How do i do group of group?

Any help is appreciated.

Re: 2 dimensions, 2 expressions each-cyclic group

sunny_talwar — Sat, 16 Jan 2016 02:40:13 GMT

What if you create two charts: 1st with Dim1 and Exp1 and 2nd with Dim2 and Exp2 and conditionally hide show them based on a button. I think that would be the best way to do what you are looking for.

Re: 2 dimensions, 2 expressions each-cyclic group

dinuwanbr — Mon, 18 Jan 2016 03:17:39 GMT

Hi,

you can use conditional enabling also in the chart. If u have doubts please upload a sample.

BR,

Dinu1

Re: 2 dimensions, 2 expressions each-cyclic group

settu_periasamy — Mon, 18 Jan 2016 04:53:53 GMT

Hi,

If you want to display your expression based on your CyclicGroup, In the Conditional display of the Expression

you can try

=GetCurrentField(GroupName)='Dim1' => Expression 1

=GetCurrentField(GroupName)='Dim2' => Expression 2

Sample Attached

Re: 2 dimensions, 2 expressions each-cyclic group

HirisH_V7 — Mon, 18 Jan 2016 05:07:21 GMT

Hi ,

Check this app two dimensions and two expressions will work according to your selections.

HTH,

PFA,

Hirish