Complex expression in Pivot Table

[#1]

Hi,

I've data in the form attached(ques) & need output as attached(a pivot table)

The problem is that Year has dynamic values which can increase upto 'n' Columns & More cols are needed to be added to the pivot table which are independent of Year.

I think:

1) I've to use only one expression.

2) I can't use Year Dimension

I concatenated the data from two sources,the Typeid field distinguishes the concatenation which i added in the data to identify the sources

as you can see in the ques. that values for Year are blank for  TYPEID=2 but still it has to be shown in the same chart with the Year Values(which suggests that year can't be used as dimension,unless you guys have other ideas).

Note that there is only 1 row for 2014....but it can be more,infact Year can increase....(2015 till....n depending on the data)

Pls help

Regards

[#2]

HELP ME

[#3]

please upload your sample application

[#4]

thanks for the reply.

Due to privacy of data it won't be possible for me to post the entire qvw file.

Could you please suggest if i can help in someother way or if you can look at the sample data & output i've posted

Thanks

[Gysbert_Wassenaar]

What you want is simply not possible. If you need that kind of output, create it in Excel.

[#6]

thanks a lot of ur answer.

I was waiting to hear from you.

Is it also not possible to create a a table like this, without using Year as dimenison

& without using set analysis :sum({<Year={2013}>} Amount) as we don't know how many Years

does the Table have ?

Is there anyway we can count the distinct Years in the table and use some expression which will result in adding the cols 2015, 2016...and so on...dynamically as the Year values increase in the table.

May be Genric loading the table to make it a CrossTable and using.........???

DIM1	DIM2	DIM3	2013	2014
-	P	Other	12067442.68	-
A	P	NP	500653.23	-
A	Q	NP	1087656.09	-
A	Q	Other	1431878.856	-
A	Q	ABO	340594.7713	-
A	R	BN	151396.2464	-
B	S	IN	32361573.96	-
B	T	BN	75963108.96	-
B	T	DE	28301155.79	-
B	T	IN	96211986.26	-
B	T	NEW	42647431.91	-
C	U	Other	17808809.6	-
C	U	ABO	4514178.11	-
C	V	BN	2018751.596	-
C	V	Other	14241727.22	-
C	V	ABO	2375031.623	-
D	P	BN	30124452.35	-
D	P	IN	6338915.4	-
D	P	NEW	1108683.55	-
D	P	Other	1139795879	298363331
D	P	ABO	2176092.9	-
D	W	Other	100525025.6	-
D	W	ABO	21158271.19	-
D	W	GRGN	38646728	-
E	X	EX	50000000	-

Thanks again !!!

[#7]

Hi Qlikviewed,

  Can you how many years data you have and which year data you want to show the output

[#8]

Hi Qlikviewed,

  Can you tell me how many years data you have and which year data you want to show the output

[#9]

This is the problem i'm facing. I also asked the same question to the user but they say that it is dynamic.

May be if I can convince them that the Data later than 2016 is not relevant to you then I might fix something but this is thing of future.

right now it has to be found out form the Data we have.

Any idea?

[#10]

ok by default which year data you need to show now itself.