topic Re: In pivot table YTD-QTD-YTD data needs to be shown across inline loaded fields and Month Dimension in QlikView

In pivot table YTD-QTD-YTD data needs to be shown across inline loaded fields and Month Dimension

ranjan_poojary — Fri, 01 Apr 2016 06:32:43 GMT

Dear All,

I have a requirement in my project in which I need to show YTD-QTD-YTD values in the same pivot chart and also a column in the last namely "Data Upload" which should contain only "N/A" as its value.There are 2 expressions "Policy Count" and "Premium Amount" and the dimension "Sr. No." and "Description" is loaded via Inline table.I have attached the sample of my report along with this discussion for your reference.Awaiting your help guys !!! Thank you..

Re: In pivot table YTD-QTD-YTD data needs to be shown across inline loaded fields and Month Dimension

jonathandienst — Fri, 01 Apr 2016 06:54:05 GMT

You need to create an extra dimension for the first row using ValueList() or an inline loaded dimension field.

I suggest that you upload a sample qvw containing some representative data for more specific help.

Re: In pivot table YTD-QTD-YTD data needs to be shown across inline loaded fields and Month Dimension

ranjan_poojary — Fri, 01 Apr 2016 10:20:49 GMT

Hello Jonathan,

I am uploading a sample data in excel which contains values from Apr-Mar 2015-2016.

I want YTD figure before selected quarter in the first column,after that QTD figure of selected quarter in middle and again YTD figure of entire year and one more column as I mentioned above is "Data Upload".

Thank you..

Re: In pivot table YTD-QTD-YTD data needs to be shown across inline loaded fields and Month Dimension

ranjan_poojary — Tue, 12 Apr 2016 13:09:33 GMT

Dear All,

Jonathan Dienst Thank you for your valuable suggestion.

The issue has been resolved by using Inline Load for the dimensions YTD-QTD-YTD and then using If condition at front end.Thanks to my colleague @Yashwin Kotian for providing this logic.

Kind Regards,

Ranjan Poojary