Dynamic Adjustment for Expression

[priyarane]

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.

[settu_periasamy]

Hi,

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

[marcus_sommer]

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

[qlikviewwizard]

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