topic Re: expression for pivot table in QlikView

expression for pivot table

Tue, 26 Nov 2013 05:56:52 GMT

Hi all,

The Required O/p is mentioned in the excel with the label O/p. Kindly find attached excel .

Thanks!!!

Tue, 26 Nov 2013 06:14:04 GMT

May i know what is the calculation of o/p measure

Tue, 26 Nov 2013 06:15:31 GMT

Could you explain breifly

Tue, 26 Nov 2013 06:21:36 GMT

Hi Saurabh,

So what is your question, do you want to know how O/p is derived?

If yes then divide Document by Actual

for example 100/0 is error so it is zero , 50 / 105 is 0.47 round it.

Regards,

Tue, 26 Nov 2013 06:32:25 GMT

if(document>actual,actual)

2. i m confused with the 2nd conditon

here actual quantity is 105 for the same batch

1000060550

and in document we have 50 ,50,50 for the same batch. i have to break the quantity 50,50,5. need to start from max date.

qlikpahadi07 — Tue, 26 Nov 2013 06:34:11 GMT

May i know what is the calculation/Logic for o/p

Tue, 26 Nov 2013 07:17:45 GMT

Hi Saurabh,

Oder (Sort) the data by "Batch", "Posting Date_BUDAT" then put if condition get O/p then use Previous() on Batch to give 50,50,5

Please give a try and let me know if still you are not able to achieve the same.

Regards,