Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rcp_17
Contributor
Contributor

Pivot table display

Dear all,

I am finding a way to display at least 2 years of data like the excel table shown below.

How can I have a similar table in Qlik sense desktop?

Thanks for you help!

 20192020
 Jan-19Feb-19Mar-19Apr-19Jan-20Feb-20Mar-20
 
expense_129.631.931.530.433.331.90.0
expense_1.119.820.721.121.622.322.00.0
expense_1.25.55.54.55.05.85.20.0
expense_1.32.63.43.30.52.82.30.0
expense_1.32.13.43.30.52.82.30.0
Labels (1)
2 Replies
Rcp_17
Contributor
Contributor
Author

Don't what happened to the excel table, but the "Mar-19" and "Apr-19" should under the "2019", just like"Jan-19". Same as others! thanks

Anil_Babu_Samineni

May be try to recreate the table again?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful