topic Re: Drill down functionality in straight table in QlikView

Drill down functionality in straight table

Anuhyak1 — Sat, 16 Nov 2024 18:57:05 GMT

I have Org Division and Sub brand value columns in Straight table

When user selects Org Division it further drill down to Subrand but in the Subbrand column it need to display Material description.

Ex:
If one Org Division value is selected, the columns will change to report the following:
Sub Brand
and Subbrand Column drill to Material Desc
Material Desc

If >1 Org Divisions are in selection criteria, table will show as-is (Org Div, Sub Brand)

Ex: IT Cosmetics is selected it drill down to YSBB CC CREAM which is Subbrand and in the Subbrand column it should display corresponding Material description (JT Simmer)

Re: Drill down functionality in straight table

joseph_morales — Thu, 12 Mar 2020 14:51:04 GMT

Hi @Anuhyak1 ,

You can replace the "Sub Brand" dimension with the following expression as dimension:

=If(GetSelectedCount([Org Division])=1,[Material Desc], [Sub Brand])

Re: Drill down functionality in straight table

Anuhyak1 — Thu, 12 Mar 2020 15:38:42 GMT

Thanks

Re: Drill down functionality in straight table

Anuhyak1 — Thu, 12 Mar 2020 22:12:01 GMT

But how to change the labels of those two fields.Subbrand label change to material description.

Re: Drill down functionality in straight table

joseph_morales — Fri, 13 Mar 2020 02:29:01 GMT

Hi @Anuhyak1,

You must put a similar expression but as text strings in the dimension label.

=If(GetSelectedCount([Org Division])=1,'Material Desc', 'Sub Brand')