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 7mon_0-1679475151363.png](https://community.qlik.com/t5/image/serverpage/image-id/103255i390C553D0F799EC3/image-dimensions/743x200?v=v2)
I would prefer to display the one entry which is actively filtered such as:
![7mon_1-1679475258685.png 7mon_1-1679475258685.png](https://community.qlik.com/t5/image/serverpage/image-id/103256i8C17326EE1D57716/image-dimensions/747x201?v=v2)
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