Getting values in the first row and %age values in the 2nd rows

[RajaShekhar-23]

Hi Folks,

I want the values on the first row and the %age values on the 2nd row is this possible.
Suggest a way out for the same.

The inputs and outputs are attached in the excel.

Output should be as attached in the pivot down image

@swuehl @kaushiknsolanki @jagan @stevedark @Colin-Albert 

Please help

Qlik Sense Business Qlik Automate Qlik DataMarket  Qlik GeoAnalytics 

[abhijitnalekar]

Hi @RajaShekhar-23 ,

I am not sure if we can achieve the desired output. but check below if this works for you?

[RajaShekhar-23]

Hi @abhijitnalekar,

This is possible but I need the output in the same format in qliksense as shown in the image which I shared

Regards

-

[RajaShekhar-23 · Accepted solution]

Use formula 1 & Chr(13)& Formula2

This is the solution