Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dynamic Header Selection

Hi Team,

I have 2 Filters in the App. 1 for selecting year and another for selection Product type(PH3,PH6 and PH9).

I have the below table which i'm showing in 3 different table.

PH3 Data
PH3PH3_descTotal QuantitySales T/ODiv_desc
2J1Armaturen127766432843Building Technology
127FLEXIBLES814592262FLEX
154WAGA-PM56675119WAGA
201PVC-UFitt.In-H.Prod.16477301046367Techno Plast
202PVC-UValve In-H. Pr.158463616212Techno Plast
     
PH9 Data
PH9PH9_descTotal QuantitySales T/ODiv_desc
2J1J54950Dummy CRE/DEB PF J54127766432843Building Technology
127140010Coupling short, stee111617710FLEX
127140011Coupling short, stee2755081FLEX
127140030Coupling short, stee1652260FLEX
     
PH6 Data
PH6PH6_descTotal QuantitySales T/ODiv_desc
2J1J54Regulierarmaturen127766432843Building Technology
127140PRIMOFIT end load814592262FLEX
154323Couplings standard54273957WAGA
154507WAGA GRIP241162WAGA
201950Solv.cement fitt.me.1402981874874Techno Plast

 

My question is like, when I select PH9 in the filter can i get the dynamic header changed and can get the details of only PH9 details.?

Kindly help  me in this.

5 Replies
Highlighted

Create the flag for each of the table and use that as filter. So it will filter based on selection of data.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Hi,

 

You can change the header with the following statement:

=if(GetSelectedCount(SELECTION) = 0, 'Table normal ', 'Table of selected Selection')

When you make a selection, the title changes.

🙂

Highlighted
Creator II
Creator II

Hi Anil,

can you brief how to create the Flag for the table?

 

Highlighted

Like this, I meant

Load PH3, PH3_desc, [Total Quantity], [Sales T/O], Div_desc, 'PH3' as Flag From <PH3 Table>

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

can u brief with this with an simple example?