Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Format issue for a pivot table

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.

4 Replies
sudeepkm
Valued Contributor III

Re: Format issue for a pivot table

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.

Not applicable

Re: Format issue for a pivot table

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

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.

sudeepkm
Valued Contributor III

Re: Format issue for a pivot table

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. 

Community Browser