topic Re: Dynamic Adjustment for Expression in QlikView

Dynamic Adjustment for Expression

priyarane — Tue, 15 Sep 2015 11:11:18 GMT

Hi Community,

I have dimension called Fieldname and Expression: CurrentValue
Under fieldname(used cross table to get dimensions as columns/ or fields), I have multiple fields like: Dim1,Dim2...etc
so, what ever is under fieldname then Currentvalues(Expression) should be the same.

PivotTable:

For ex(PivotTable):

Dimension(FieldName):
Dim1
Dim2

Exprssion(CurrentValue):
if(FieldName='Dim1',Dim1,
if(FieldName='Dim2',Dim2))

right now we are following above example.
but I have multiple columns under dimension(FieldName) from Dim1......to Dim311
so, What I am looking for what ever is under Fieldname it should be populate under CurrentValue
Ex:
Fieldname:
Dim100
Dim200

thene expression(CurrentValue) should show Dim100,Dim200 values automatically.

Re: Dynamic Adjustment for Expression

settu_periasamy — Tue, 15 Sep 2015 14:54:03 GMT

Hi,

Can you create the sample qvw and expected output in excel?

Re: Dynamic Adjustment for Expression

marcus_sommer — Wed, 16 Sep 2015 08:30:52 GMT

Have a look here to several various approaches to create and use dynamically dimensions and expressions: https://community.qlik.com/search.jspa?q=dynamic+dimension&type=document

- Marcus

Re: Dynamic Adjustment for Expression

qlikviewwizard — Wed, 16 Sep 2015 08:37:47 GMT

Hi, Please attach some sample data and provide your expected results.