topic Re: Design a Self-Service Sheet in QlikView

Design a Self-Service Sheet

mohammedsleem — Wed, 10 Feb 2016 13:04:02 GMT

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.

Re: Design a Self-Service Sheet

avinashelite — Wed, 10 Feb 2016 13:30:30 GMT

check this

Dynamic Dimension selection for a pivot table

Re: Design a Self-Service Sheet

dgreenberg — Wed, 10 Feb 2016 14:10:40 GMT

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:

Re: Design a Self-Service Sheet

Peter_Cammaert — Wed, 10 Feb 2016 14:23:32 GMT

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