Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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