Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
7mon
Contributor II
Contributor II

Line graph: drill down but show active filter only

Hi everybody,

I try to create a line graph which displays the development of stock, but only the one entry of the dimension which is actively filtered.

To provide some information about the actual stock, a table with a drill down dimension sorted descending by stock quantity is displayed at the left side and a line graph should display it on the right.
If the drill down dimension is used in the line graph, all available entries of the dimension are displayed, such as:

7mon_0-1679475151363.png

I would prefer to display the one entry which is actively filtered such as:

7mon_1-1679475258685.png

To display the line graph Iike this, I created a dimension using the following expression:

=if (GetSelectedCount([M.MATERIALNumName_$(vLang)])>0,[M.MATERIALNumName_$(vLang)],
if (GetSelectedCount([MG.MATL_GROUP5_$(vLang)])>0, [MG.MATL_GROUP5_$(vLang)] ,[MG.MATL_GROUP4_$(vLang)]
)) 

Can you come up with a more efficient way of displaying the filtered entry in a dimension only using a drill down dimension?

Many thanks for your help in advance

Simon

Labels (1)
0 Replies