Problem set analysis using QuarterStart

Wed, 15 Jun 2011 20:48:45 GMT

For an application I want to show data from the currently selected quarter and from previous quarters based on the selection. I've create a field StartQuarter within the master Calendar which hold the juliandate for the start of the Quarter. Now I use the set analysis displayed below.

Current month:

=SUM({$<StartQuarter = {$(=QuarterStart(StartQuarter,0)*1)}>}SumSales)

Previous Month:

=SUM({$<StartQuarter = {$(=QuarterStart(StartQuarter,-1)*1)}>}SumSales)

I know that for the first expression the set analysis is unnecessary but I did this for uniformity. The problem with the expression is that it won't display the value when I use -1 instead of 0 for the QuarterStart command. I checked the output from the QuarterStart outside the set analysis and it does return the correct JulianDate however it won't work in the set analysis. Any suggestions?

topic Problem set analysis using QuarterStart in QlikView

Problem set analysis using QuarterStart