Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

robert2012
New Contributor III

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!

Tags (1)
1 Solution

Accepted Solutions

Re: Adaption of names with drill down

Try it with this condition within your second dimension:

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

- Marcus

5 Replies
pradosh_thakur
Valued Contributor III

Re: Adaption of names with drill down

Hi

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

Capture.PNG

regards

Pradosh

robert2012
New Contributor III

Re: Adaption of names with drill down

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!


Re: Adaption of names with drill down

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

- Marcus

robert2012
New Contributor III

Re: Adaption of names with drill down

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

1000 General

Drillodwn to KST2 =>

1100Car

Re: Adaption of names with drill down

Try it with this condition within your second dimension:

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

- Marcus