Format changes in Pivot table

[#1]

Hi All,

I am new in QlikView.

We have created a report which will show the previous day values in the report. For example, when we select 10^th July 2016 report then it will display the 9^th July data and Opening balance will be calculated till 8^th July. And Closing Balance value will be the sum of Credit, Debit and Opening Balance. Please refer the attached Screen1.JPEG. We have four expressions: Credit, Debit, Opening Balance and Closing Balance

But we need table format in our dashboard as Screen2.JPEG, could you please help me to achieve the format as Screen2.JPEG.

Thanks & Regards

Jhanaarthanan

[Gysbert_Wassenaar]

Ah, you want to use Qlikview as a spreadsheet. I recommend not trying it, but if you have a high pain tolerance go right ahead. Perhaps this blog post helps: How IntervalMatch Solved My Profit and Loss Dilemma