topic Re: Format issue for a pivot table in QlikView

Format issue for a pivot table

Tue, 02 Aug 2016 10:22:41 GMT

Dear All,

I have created a pivot table having the dimension Site Name and the measures-Amount,Qty,Profit.I have created the following expressions for MTD,QTD and YTD.But I want the table as same as the format of the attached excel.If I introduce a mapping table for the same,the expressions are repeated for MTD,QTD,YTD.Please help me out.

Re: Format issue for a pivot table

sudeepkm — Tue, 02 Aug 2016 12:04:05 GMT

as long as you load the data grouping your facts as per time dimensions you can build it in QlikView.

Please take a look at the sample attached.

Re: Format issue for a pivot table

Tue, 02 Aug 2016 12:16:52 GMT

Dear Sudeep,

Thanks for your Quick response.Are U Loading an excel inside the QVW?Can U share the same?But my amount,Qty,Profit are generated from the Fact tables?How are U specifying Type as MTD,YTD,QTD please explain.

Re: Format issue for a pivot table

sunny_talwar — Tue, 02 Aug 2016 12:59:27 GMT

I think if you can provide the raw data behind the output needed, we might be able to provide you with a better way of doing this for your data.

Re: Format issue for a pivot table

sudeepkm — Tue, 02 Aug 2016 13:07:53 GMT

yeah I just grouped (created a new field Type) them as per the output report in the xls itself. if you have a sample qvw then I can check how your actual data load looks like. I think you might have a transaction table that might have data at daily or monthly level and from which you might have define the time dimensions like Month, Qtr and Year.