Calculation on the basis of date range in qliksense

[Rsaiq]

I have explained all the problem in the attached excel sheet.I am new to qliksense please help me to resolve this solution

And also attched the QVF file.

Thanks

[Anil_Babu_Samineni · Accepted solution]

Try this may be?

Opening: Sum({<Type=,[GL Date]={">=$(=Min({1} [GL Date]))<=$(=Min([GL Date]))"}>}Amount)

Purchase: Sum({<Type={'01.Purchases'},[GL Date]={">=$(=Min([GL Date]))<=$(=Max([GL Date]))"}>}Amount)

Sale: Sum({<Type={'02.Sales'},[GL Date]={">=$(=Min([GL Date]))<=$(=Max([GL Date]))"}>}Amount)

Closing: Sum({<Type=,[GL Date]={">=$(=Min({1}[GL Date]))<=$(=Max([GL Date]))"}>}Amount)

[Rsaiq]

Thanks for Reply and help.

All Calculataions are working as  per the requirement .

Thnaks once again.