Format changes in Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Format changes in Pivot table

Gysbert_Wassenaar — Sat, 11 Feb 2017 18:06:57 GMT

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

topic Re: Format changes in Pivot table in QlikView

Format changes in Pivot table

Re: Format changes in Pivot table