Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've got 20 dimensions which I want to put inside a filter pane for the user to select one or more dimensions from. In turn, the selections are shown in a table below. Thus, the table can grow as the user selects more dimensions.
Currently the filter pane pushes out the data inside the dimensions, which is not something I want. So the first question is: what is the solution to just show the dimensions name, instead of it's data. Second, as a bonus, how can I rename the dimensions inside the filter pane, so that it is not showing its original name. For example, 122.Male_Female_Unisex should be shown as Gender.
Last, to show the column in the table, what would be an appropriate way to handle this? Things like if(GetSelectedCount(122.Male_Female_Unisex),1,0) in the 'Show column if' function box?
Your help is much appreciated, thanks.
Hi,
This is the whole idea of a filter pane, so it will always show the values if it has the space for it. When you don't want to show the data that's inside, make the filter pane smaller. You can rename the dimensions when you add a dimension, go to Edit chart, Data, Dimensions, Title. This is where you can edit the title.
Your last solution can work, you can also do this based on a variable. But this depends on what you want to achieve.
Jordy
Climber
Hi Jordy,
Thanks for your response. I know that's the main purpose of the filter pane. However, it is not useful to select values from it in my case, since 20*N, making it unnecessary large. Therefore I was hoping if someone knows a hack-around, just show the dimensions within the filter pane.
Another way of asking a solution to my problem would be; what is a convenient way to let a user select one or more dimensions, without resorting creating 20 buttons for each dimension to select?
Hello,
In my understanding ,You are looking for something called as custom report.
There are two solution :
1.You can use the extension of Climber Custom Report.
https://github.com/ClimberAB/ClimberCustomReport
2.If you are using latest version of Qlik sense,using show or Hide features(Show column if) of Table you can make custom report.
https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/.
Thanks and Regards,
Sonu Sagar
Nope, this still doesn't provide the results that I envision. See an example below. Also note, that in my case, the dimensions contain text data, not numeric.