Previous Balance Calculation

[Anonymous]

Previous Balance Calculation

Good afternoon everyone,

I'm starting with Qlik Sense and in this community and would like to know if anyone could help me with the following question.

I am using a maintenance order worksheet as Qlik data source. I would like to present the result in Qlik in the same way that it is calculated in this worksheet.

In the data upload a field called "Period" was created in the format "Month / 9999" (Aug / 2017).

When selecting the month of August for example I would like to calculate the previous balance of the orders, which is the sum (considering some criteria) of the orders of previous months. It turns out that by selecting this period it is no longer possible to calculate view information from previous months to obtain the previous balance.

How could i solve this question?

Thank you,

[achakilam1022]

Hi,

May be you can create a current month flag as

if(MonthName(Period)=MonthName(today()), 1, 0) as Current_Month_Flag.

Then use Current_Month_Flag in set analysis while calculating Sum of orders of previous months.

[Anonymous]

Tks Amuktha.

I´ll try this way