Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Can you create the sample qvw and expected output in excel?
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
Hi, Please attach some sample data and provide your expected results.