topic Re: table in QlikView

table

yogitamehta10 — Fri, 03 Nov 2017 11:49:10 GMT

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 3^rd column will show the current year data and 4^th column will show the difference between two columns.

Re: table

prat1507 — Fri, 03 Nov 2017 11:51:11 GMT

Hi Yogita

Could you please provide some sample data?

Regards
Pratyush

Re: table

yogitamehta10 — Fri, 03 Nov 2017 12:00:18 GMT

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

Re: table

yogitamehta10 — Fri, 03 Nov 2017 12:02:24 GMT

that is how I want to show in to qlikview.

	2017	2016	var
KPI1
KPI2
KPI3
KPI4
KPI5

Re: table

yogitamehta10 — Fri, 03 Nov 2017 13:05:11 GMT

Any response ??

Re: table

Anil_Babu_Samineni — Fri, 03 Nov 2017 13:07:24 GMT

What is var in your List?

Re: table

yogitamehta10 — Fri, 03 Nov 2017 13:12:07 GMT

difference between column 2 AND COLUMN 3

Re: table

yogitamehta10 — Fri, 03 Nov 2017 13:16:39 GMT

Please chcek the sample data.

Re: table

Anil_Babu_Samineni — Fri, 03 Nov 2017 13:24:17 GMT

PFA

Re: table

yogitamehta10 — Fri, 03 Nov 2017 13:32:48 GMT

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

Re: table

yogitamehta10 — Mon, 06 Nov 2017 09:33:29 GMT

Any recommendations ?

Re: table

prat1507 — Mon, 06 Nov 2017 10:08:18 GMT

PFA the required app.

Regards
Pratyush

Re: table

tresB — Mon, 06 Nov 2017 10:14:31 GMT

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().

Re: table

yogitamehta10 — Thu, 09 Nov 2017 11:48:57 GMT

How did you achieve that , Please advise ?

Re: table

tresB — Thu, 09 Nov 2017 12:35:42 GMT

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

Re: table

yogitamehta10 — Thu, 09 Nov 2017 13:34:21 GMT

I cant see your attachments ..

just a screenshot I can see.

Re: table

tresB — Fri, 10 Nov 2017 04:26:12 GMT

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