Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
prat1507
Specialist
Specialist

Hi Yogita

Could you please provide some sample data?

Regards
Pratyush

yogitamehta10
Creator
Creator
Author

   

year KPi1 KPi2KPi3KPI4
2017345679233
2017352322222
2017346452421
2017343444222
201634364411
20163443411
20163423211
201634342511
yogitamehta10
Creator
Creator
Author

that is how I want to show in to qlikview.

   

20172016var
KPI1
KPI2
KPI3
KPI4
KPI5
yogitamehta10
Creator
Creator
Author

Any response ??

Anil_Babu_Samineni

What is var in your List?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
yogitamehta10
Creator
Creator
Author

difference between column  2 AND COLUMN 3

yogitamehta10
Creator
Creator
Author

Please chcek the sample data.

Anil_Babu_Samineni

PFA

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
yogitamehta10
Creator
Creator
Author

without cross  table is this possible , I don't want to touch .. data model.