Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pedromsouza
Creator
Creator

Second dimension (real) in a table with synthetic dimensions

Is it possible to add real dimensions (standard fields) in a synthetic dimension pivot table?

If I have a table like this...

dim (valuelist) 

A

B

C

and expression (pick/match) $(calcA), $(calcB),$(calcC).

 

Is is possible to add a standard secondary dimension that only related to dim B ($calcB)?

Qliking since '09
Labels (1)
1 Reply
MayilVahanan

Hi

You can create the dummy field in the script by using inline load with valuelist values.

And then, add 2nd dim like below,

If(DummyField = 'B', ursecondarydimension)

hope it helps

Thanks & Regards,
Mayil Vahanan R