Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Example is
Oct Nov Dec Quarter Total
Revenue 50 50 50 150
BalanceSheet 50 50 50 50