topic Re: Show Group Dimension in Calculated Dimension in QlikView

Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 02:33:12 GMT

Hi,

I have a question, I have a group dimension named Ar_Br contains two fields, lets say area and brand. I want to show the dimension Ar_Br using calculated dimension, when I write Ar_Br in calculated dimension it returns red underline but the expression is OK. It can run perfectly, but there is no arrow for drill up the dimension. Do you know how to show the drill up arrow ?

Really appreciate your help

Thanks

Re: Show Group Dimension in Calculated Dimension

maksim_senin — Tue, 14 Jul 2015 02:41:19 GMT

Hi,

It's hard to understand your purposes, but at the first glance I'd suggest to use conditionally displayed dimension instead. That definitely guarantees presence drill-down/through arrows.

Best regards,

Maxim

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 02:41:22 GMT

Hi,

Can you post a screen shot?

Re: Show Group Dimension in Calculated Dimension

fkeuroglian — Tue, 14 Jul 2015 02:44:05 GMT

The arrow in group dimension, only appears if your group is drill down(Hirechachy)

you have to create this kind of group

Go to the properties of the group and check if it is a drill down group or ciclyc group

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 02:49:33 GMT

Are you getting like the below screen shot?

Instead of Calculated dimension, try to add the Group dimension using the Add Button.

Re: Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 02:59:05 GMT

Hi Settu,

Yes Settu i got that error. I cant use add because I need to use calculated dimension. I'm using If condition to show the dimension. Do you have any idea ?

Thanks

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 03:06:29 GMT

Hi,

Try to use the

=GetCurrentField("GroupName")

=GetCurrentField(GroupName)

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 03:14:02 GMT

if(GetCurrentField("GroupName")='Dim1',Display value)

Re: Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 04:01:37 GMT

Hi Settu,

i mean i want to use this expression in calculated dimension (straight table)

=if(fieldname<>'ABC' and fieldname<>'DEF', Ar_Br)

Ar_Br is my group dimension i've created contain two field (Area and Brand)

Thanks

Re: Show Group Dimension in Calculated Dimension

maksim_senin — Tue, 14 Jul 2015 04:06:37 GMT

Hi,

This means it's better to add the expression to calc. condition of Ar_Br dimension and not to deal with calc. dimension at all.

Best regards,

Maxim

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 04:35:26 GMT

Hi,

What if the Field name Doesn't met your criteria.

like if field name='XYZ', What do you want to show?

Re: Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 04:56:54 GMT

Hi Max,

i have try to put if condition in expression, but it shows different value when i put if condition in the dimension (calculated dimension). Do you know why ?

Thanks

Re: Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 04:57:41 GMT

Hi Settu,

I dont want to show the dimension if the field name doesnt meet the criteria.

Still dont get the idea

Thanks

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 05:02:19 GMT

Hi,

Can you try the Enable Conditional formatting

Add the Dimension as usual(No Calculated Condition) and in the Enable Conditional, put your condtion

(no need to put if condition) See the below screen shot

Re: Show Group Dimension in Calculated Dimension

maksim_senin — Tue, 14 Jul 2015 05:05:19 GMT

Please see settu_periasamy's post, the setting name is Enable Conditional

Re: Show Group Dimension in Calculated Dimension

Tue, 14 Jul 2015 05:39:41 GMT

Hi Settu,

I've try your method but it give me different value. Really confuse about it.

do you know why ?

Thanks

Re: Show Group Dimension in Calculated Dimension

settu_periasamy — Tue, 14 Jul 2015 05:43:31 GMT

is it possible to provide sample and expected result?

Re: Show Group Dimension in Calculated Dimension

antoniotiman — Tue, 14 Jul 2015 14:52:33 GMT

Hi Indra,

if You have 2 fields in Your AR_BR group (area,brand)

You can create Group whit 2 distinct expressions

Add expression 1

If(Fieldname <> 'XXX' and Fieldname <> 'yyy',area) //(label area)

Add Expression 2

If(Fieldname <> 'XXX' and Fieldname <> 'YYY',brand) //(label brand)

Regards,

Antonio

Re: Show Group Dimension in Calculated Dimension

Wed, 15 Jul 2015 00:37:58 GMT

Hi Antonio,

Wow thanks, it works and solved my problem.

Thanks