Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rdsuperlike
Contributor

2 dimensions, 2 expressions each-cyclic group

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.

4 Replies

Re: 2 dimensions, 2 expressions each-cyclic group

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.

dinuwanbr
Contributor III

Re: 2 dimensions, 2 expressions each-cyclic group

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

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

HirisH_V7
Honored Contributor

Re: 2 dimensions, 2 expressions each-cyclic group

Hi ,

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

HTH,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”