Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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