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

[#1]

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.

[reddy-s]

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.

[#3]

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.

[#4]

Example is

                         Oct     Nov      Dec     Quarter Total

Revenue            50       50          50          150        

BalanceSheet     50        50          50          50