Design a Self-Service Sheet

[mohammedsleem]

Dears,

in one of our QVWs, we need to provide a sheet that contains a blank chart in the middle, list of dimensions in the left and list of measures in the right.

So the user will be able to select the dimensions and it will be automatically used in the blank chart. The user will select the measures and they will be automatically used in the chart.

I know that this is applicable and we can do it by Qlik. i sow this design before, but I really want to know how i can implement it.

please if you have any sample that can show me the concept of how I can implement that please share it with me.

[avinashelite · Accepted solution]

check this

Dynamic Dimension selection for a pivot table

[dgreenberg]

One thing that I sometimes do is build this with $Field.

I have a list box for dimensions with $Field

I setup variables 1 - however many needed with =Subfield(Concat(DISTINCT $Field, ','), ',', 1) for first $Field but I setup the variables in an Excel sheet because I can use the power of Excel to avoid having to manually create these variables where just the integer changes.

Then in the chart I use ='$(vDim1)', ='$(vDim2)'... with a condition to enable the dimension.

I read these vDIM1 variables from a spreadsheet because I can use a formula in Excel to change it quicker.

The Excel sheet looks like this:

[Peter_Cammaert]

Search the Community for documents/discussions about "Ad-hoc report". You will find a lot of them, all variations on a theme explained quite well by Jennell McIntire in Customizable Straight Table

Good luck,

Peter