https://community.qlik.com/t5/App-Development/Second-dimension-real-in-a-table-with-synthetic-dimensions/m-p/1943735#M77761 <P>Hi</P> <P>You can create the dummy field in the script by using inline load with valuelist values.</P> <P>And then, add 2nd dim like below,</P> <P>If(DummyField = 'B', ursecondarydimension)</P> <P>hope it helps</P> Wed, 15 Jun 2022 04:10:16 GMT MayilVahanan 2022-06-15T04:10:16Z https://community.qlik.com/t5/App-Development/Second-dimension-real-in-a-table-with-synthetic-dimensions/m-p/1943711#M77759 <P>Is it possible to add real dimensions (standard fields) in a synthetic dimension pivot table?</P> <P>If I have a table like this...</P> <P>dim (valuelist)&nbsp;</P> <P>A</P> <P>B</P> <P>C</P> <P>and expression (pick/match) $(calcA), $(calcB),$(calcC).</P> <P>&nbsp;</P> <P>Is is possible to add a standard secondary dimension that only related to dim B ($calcB)?</P> Wed, 15 Jun 2022 01:22:38 GMT https://community.qlik.com/t5/App-Development/Second-dimension-real-in-a-table-with-synthetic-dimensions/m-p/1943711#M77759 pedromsouza 2022-06-15T01:22:38Z https://community.qlik.com/t5/App-Development/Second-dimension-real-in-a-table-with-synthetic-dimensions/m-p/1943735#M77761 <P>Hi</P> <P>You can create the dummy field in the script by using inline load with valuelist values.</P> <P>And then, add 2nd dim like below,</P> <P>If(DummyField = 'B', ursecondarydimension)</P> <P>hope it helps</P> Wed, 15 Jun 2022 04:10:16 GMT https://community.qlik.com/t5/App-Development/Second-dimension-real-in-a-table-with-synthetic-dimensions/m-p/1943735#M77761 MayilVahanan 2022-06-15T04:10:16Z