topic Modified Pivot table report in QlikView

Modified Pivot table report

prma7799 — Mon, 12 Mar 2018 11:52:13 GMT

Hi All,

I need to create shipment status report month wise but not understand how to add measure which is highlighted in green color.

PFA for expected output.

Re: Modified Pivot table report

prma7799 — Mon, 12 Mar 2018 12:21:03 GMT

PFA work file and QVD...

I need to achieve output as per Expected report excel.

Re: Modified Pivot table report

isingh30 — Mon, 12 Mar 2018 14:37:48 GMT

You can do this in visual cues tab. But you have to set some condition like < measure or > measure. Something like that.

Re: Modified Pivot table report

ajaysingh285 — Mon, 12 Mar 2018 15:17:58 GMT

Hi P M,

Please find the attached file.

I have made as per your changes and you can add in expression for Jan,Feb... as per your analysis purpose.

Thanks,

Ajay

Re: Modified Pivot table report

prma7799 — Tue, 13 Mar 2018 04:38:56 GMT

Hi Ajay,

This is not i am looking for ..

I need financial year also. I don't want create it manually.

PFA expected output.

Hi All , stalwar1 , tresesco,

Anyone can help me on this?

Thanks

Re: Modified Pivot table report

tresB — Tue, 13 Mar 2018 11:17:24 GMT

I am not sure I understand your requirement. If it's about getting fiscal year on top of the Months only, I am afraid that might not be feasible like that. Alternatively, you could create Fiscal Year in the script and then use Fiscal Year and Month as dimensions, and then pulling them to the columns is what usually should be done. However, since you have few more calculations which are independent of the financial year context, that possibility also looks grim to me. I can think of trying it with valuelist() as a chance (along with the year, month as dimension approach), but not sure if that could help or not here.

Or, else, try calculating the additional calculations in the script or as calculated dimension (not a good recommendation though). and then use the dimensions and pull across solution.