Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QS do it support Daimension Dynamic ?

Hi All

In QV I used to design report which allow dynamic change of Daimension.

When I try to binary load my QV QVW file to QS. I notice it does not support the above mention. I think it is Because QS does not all user go to system variable to declare columns variable.

Any work around ?

1 Solution

Accepted Solutions
dverbeke
Contributor III

Re: QS do it support Daimension Dynamic ?

There is a work around:

Define an inline table in your script with your fields.

FIELD:

LOAD * INLINE [

    FIELD

    beer_name

    brewery_id

];

Then create a field in a table and use the following as a dimension:

$(=FIELD)

Once you select a field it should display the values of that field you selected in the filter pane.

It is not the same, but a very close approximation.

Kind Regards,

Dion

2 Replies
dverbeke
Contributor III

Re: QS do it support Daimension Dynamic ?

There is a work around:

Define an inline table in your script with your fields.

FIELD:

LOAD * INLINE [

    FIELD

    beer_name

    brewery_id

];

Then create a field in a table and use the following as a dimension:

$(=FIELD)

Once you select a field it should display the values of that field you selected in the filter pane.

It is not the same, but a very close approximation.

Kind Regards,

Dion

paulyeo11
Valued Contributor II

Re: QS do it support Daimension Dynamic ?

Hi Sir

Thank you for your advise.

My existing diamension is below , may i know it is possible to modify to your ?

For Each i in 101,102,103,104

WhatIfDimension$(i):

LOAD * INLINE [ 

  Pls select $(i)st Dim,Column$(i)

  CU_ID,cust_id

  COY,company

  BRA_C, BRAND_

  BRA_F, bRAND

  BRA_D,BRAND_SUB

  ];

NEXT i;