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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
yogitamehta10
Creator
Creator

table

I want to create a table where all the KPIS on right side in one column and second column will show the last year data and 3rd column will show the current year data and 4th column will show the difference between two columns.

16 Replies
yogitamehta10
Creator
Creator
Author

Any  recommendations ?

prat1507
Specialist
Specialist

Hi

PFA the required app.


Regards
Pratyush

tresesco
MVP
MVP

It's possible. But that would complex and very cumbersome and hard for maintenance and hence not recommended. For such requirement the data should be handled in script. PFA for not recommended solution using valuelist().

Capture.JPG

yogitamehta10
Creator
Creator
Author

How did you achieve that , Please advise ?

tresesco
MVP
MVP

Did you check the dimension (calculated) and expression used? Or, are you using personal edition of qv and could not open my attachment?

yogitamehta10
Creator
Creator
Author

I cant see your attachments ..

just a screenshot I can see.

tresesco
MVP
MVP

Attachment is there. Are you opening the thread from Inbox? Open it from the discussion thread directly - you should be able to see it.