Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Balance Sheet Data should show only last month data when Qtr Selected.

I am trying to create a BS report in QlikSense and want to show it quarterly and as BS data is as of that month when i create a quarterly report the numbers add up for all the month.Is there a way we can show the value of the last month of the quarter/year values if the acct is a BS type.Thanks.

3 Replies
reddys310
Honored Contributor II

Re: Balance Sheet Data should show only last month data when Qtr Selected.

Hi Sujan,

Do you have a master calendar for these cancellations? What are the expressions which you are using to compute the totals. Your task would become easy if you have a master calendar for calculations.

Thanks,

Sangram.

Not applicable

Re: Balance Sheet Data should show only last month data when Qtr Selected.

Hi Sangram,

I do not have a master calendar in Qlik but using a date dimension table from DWH.How can i acheive this with a master calendar?

Appreciate your reply.

Not applicable

Re: Balance Sheet Data should show only last month data when Qtr Selected.

Example is

                         Oct     Nov      Dec     Quarter Total

Revenue            50       50          50          150        

BalanceSheet     50        50          50          50