Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adaption of names with drill down

Hi all,

I have the following table:

KST1Name KST1KST2Name KST2PriceCost
1000General1100Car32

1000

General1200Food56
2000Material2100steal64
2000Energy2200oil78

Now I want to show this in a pivot-table with a drill-down for KST1 und KST2 => this is working, but how do I get the names "Name KST1" and "Name KST2" into the pivot-table synchronized to the drill-down for KST1 and KST2?

Thank u for helping!

1 Solution

Accepted Solutions
marcus_sommer

Try it with this condition within your second dimension:

if(getcurrentfield(GroupName) = 'KST1', [Name KST1], [Name KST2])

- Marcus

View solution in original post

5 Replies
pradosh_thakur
Master II
Master II

Hi

are you talking about the label name ? you can change it in the edit drill down group

Capture.PNG

regards

Pradosh

Learning never stops.
Anonymous
Not applicable
Author

HI Pradosh,

thank you for your answer, but I don’t want to change the label name.

I have a drwill-down for KST1=>KST1: how do I get the right name for the status of drill-down => drill-down: KST1 => show name1 ; drilldown: KST2 => show name2?

Thank you very much!


marcus_sommer

With getcurrentfield(GroupName) you could query which item is the current one within your dimension-group.

- Marcus

Anonymous
Not applicable
Author

Thank you, but I need the result from the group name2:

1000 General

Drillodwn to KST2 =>

1100Car
marcus_sommer

Try it with this condition within your second dimension:

if(getcurrentfield(GroupName) = 'KST1', [Name KST1], [Name KST2])

- Marcus