Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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.