Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Need help with Quarter Calculations

Hi,

I am new to Qlikview and learning the ropes. I am kind of stumped on this issue and was hoping someone can help me out.

I have a scenario where i Have a table with patients, disease and date. The requirement is to display count of patients in a bar chart by disease as a stacked bar by Quarter Year for current and last 3 quarters based on year and month selected.

The issue is i have created a master calendar and was able to get quarter year and was able to get last 3 quarter values using the following expression

Count({<YearQuarterID= {"<=$(=max(YearQuarterID)) >$(=max(YearQuarterID)-4) "}, Year=, Month=, Date=>} [Patient ID])

Now i was informed I need not aggreate the months values in a QTR but display the values for the last month in each quarter. So if some one selects Year = 2013, Month = Feb. The chart should display Q1 13 with Feb count value as one bar followed by Q4 12 with Dec 12 count value and so on...

Anyone have any ideas how we can do this? Or get the count of the last month of the quarter in which the month selected falls in?

3 Replies
tresesco
MVP
MVP

this?

Count({<YearQuarterID= {$(=max(YearQuarterID)}, Year=, Month=, Date=>} [Patient ID])

Not applicable
Author

No sorry, when i try that all i get is no data to display.

Not applicable
Author

So with the help of jagan mohan's previous post  i was able to write an expression to get the max month value in a quarter

=sum(Aggr(If(Max(TOTAL<YearQuarter, Disease> YearMonthID) = YearMonthID, Count([Patient ID])), YearQuarter, Disease YearMonthID))

now is there a way i can display last 3 quarters values?