Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Yogita
Could you please provide some sample data?
Regards
Pratyush
year | KPi1 | KPi2 | KPi3 | KPI4 |
2017 | 34 | 56 | 79 | 233 |
2017 | 35 | 23 | 22 | 222 |
2017 | 346 | 45 | 24 | 21 |
2017 | 34 | 34 | 44 | 222 |
2016 | 34 | 36 | 44 | 11 |
2016 | 34 | 43 | 4 | 11 |
2016 | 34 | 23 | 2 | 11 |
2016 | 34 | 34 | 25 | 11 |
that is how I want to show in to qlikview.
2017 | 2016 | var | |
KPI1 | |||
KPI2 | |||
KPI3 | |||
KPI4 | |||
KPI5 |
Any response ??
What is var in your List?
difference between column 2 AND COLUMN 3
Please chcek the sample data.
PFA
without cross table is this possible , I don't want to touch .. data model.