Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Format changes in Pivot table

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 10th July 2016 report then it will display the 9th July data and Opening balance will be calculated till 8th 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


1 Reply
MVP & Luminary
MVP & Luminary

Re: Format changes in Pivot table

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

talk is cheap, supply exceeds demand