Dynamically change the label columns based on condition in straight table

Anuhyak1 — Sat, 16 Nov 2024 00:58:18 GMT

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

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

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

If user drill down to Sub Brand or if user select Sub Brand the columns should change to Sub Brand and material desc. How to implement these 3 changes in dimension label?

Re: Dynamically change the label columns based on condition in straight table

rubenmarin — Thu, 26 Mar 2020 18:21:19 GMT

Hi, below the dimensions box there is a box to enable conditional dimensions.

Add both fields as dimensions: Sub Brand and Material Desc

- Condition for Sub Brand can be: GetPossibleCount([Org Division])>1

- Condition for Material Desc can be: GetPossibleCount([Org Division])=1

So only one dimension is enabled and it shold work as the drill down.

topic Dynamically change the label columns based on condition in straight table in QlikView

Dynamically change the label columns based on condition in straight table

Re: Dynamically change the label columns based on condition in straight table