Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing previous quarter value

I'm creating a balance sheet report and once the year and quarter input box is set, i need to show balanace until the specified quarter for previous year, balance for the specified year until previous quarter and also balance from current year until the specifiesd quarter.

Since the quarter that user specifies is in string value i'm having a difficult time in minusing the quearters.

First Expression : sum(if(PostingYear=ReportingYear-1 and PostingQuarter<=ReportingQuarter, Amount))/1000  (The values for this are correct)

(The values for the below are not showing correctrly)

Second Expression: sum(if(PostingYear<=ReportingYear and PostingQuarter<ReportingQuarter, Amount))/1000

Third Expression: sum(if(PostingYear<=ReportingYear and PostingQuarter<=ReportingQuarter, Amount))/1000

Can anyone help me on this or any other suggestions to do this better are welcomed.

0 Replies