Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Group Dimension in Calculated Dimension

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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

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

View solution in original post

18 Replies
maksim_senin
Partner
Partner

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

settu_periasamy
Master III
Master III

Hi,

Can you post a screen shot?

fkeuroglian
Partner
Partner

Hi

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

settu_periasamy
Master III
Master III

Are you getting like the below screen shot?

Capture111.JPG

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

Not applicable
Author

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

settu_periasamy
Master III
Master III

Hi,

Try to  use the


=GetCurrentField("GroupName")

or

=GetCurrentField(GroupName)

settu_periasamy
Master III
Master III

like

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

Not applicable
Author

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

maksim_senin
Partner
Partner

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