topic Re: How to define Dimensions using parameters in QlikView

How to define Dimensions using parameters

rahulhv1 — Wed, 02 Jul 2014 07:10:56 GMT

Hello friends,

I am trying genarate chart on the basis of end user's dimentison selection , in short i wish to pass dimention of the chart as a parameter e.g. I am using $Field in multibox and as end user i an select any one field in drop down list. How to transfer this selected field as chart dimension. ?

Re: How to define Dimensions using parameters

Wed, 02 Jul 2014 08:13:07 GMT

Create a varaible

v1:

=GetFieldSelections($Field)

In the chart Dimension define the calc dimension as =$(v1)

Regards,

Prabhu

Re: How to define Dimensions using parameters

rahulhv1 — Wed, 02 Jul 2014 09:43:22 GMT

Thank you so much Prabhu Pandian i was missing $ and just putting name of variable. Now i have some other issue,

when i am selecting any field, which has numaric value e.g. Company Code which has valuse as 1000,1100,4000 etc. whenever i select this, it gives Error In Calculated dimention , how to fix it

Re: How to define Dimensions using parameters

VishalWaghole — Wed, 02 Jul 2014 09:47:53 GMT

Hi Rahul

Please find attached image,

go to Enable Conditional option and apply condition as

=SubStringCount(Concat( dimension from multibox, '|'), 'Customer')

Hope you understand.....

For more detail

go to C:\Program Files\QlikView\Examples\Documents and find What new in QlikView11 Application.

In Report tab of this application have logic that you want.

- Regards,

Vishal Waghole

Re: How to define Dimensions using parameters

Anonymous — Wed, 02 Jul 2014 09:49:55 GMT

Hi,

Why dont u put all the dimensions in a cyclic group and try? It is similar to what u require.

HTH

Ravi N.

Re: How to define Dimensions using parameters

VishalWaghole — Wed, 02 Jul 2014 09:51:16 GMT

Please refer this application...

Re: How to define Dimensions using parameters

Wed, 02 Jul 2014 09:52:13 GMT

It should work fine Rahul.

If possible share the app, will figure out.

Regards,

Prabhu

Re: How to define Dimensions using parameters

rahulhv1 — Wed, 02 Jul 2014 09:58:38 GMT

Hi,

Actually i wish to give liberty to end user to select fields in dimension & expressions as per his/her wish.

Re: How to define Dimensions using parameters

rahulhv1 — Wed, 02 Jul 2014 09:59:18 GMT

Its working some time and gives error at some time

Re: How to define Dimensions using parameters

Anonymous — Wed, 02 Jul 2014 10:15:46 GMT

Ok, fine, getfieldselections($fields) be your dimension..

Re: How to define Dimensions using parameters

stigchel — Wed, 02 Jul 2014 10:25:27 GMT

Fields with e.g. spaces in the name must be enclosed by brackets, use:

=[$(v1)]

For your dimension