Using Set Analysis Dates along with Another Argument

[#1]

I have created a pivot table that looks like the following:

For the expression for quotes I have

Count({$<QvsI = {"Q"}, OriginalDate={"=CalendarDateKey"}>}QvsI).

What I need is for Quotes to be counting the number of records where QvsI = Q and OriginalDate = CalendarDateKey. The first one meets this criteria. Why would it not be counting it but it is counting PolicyNumberC=5018237? I think I may need to be using the date() function somewhere in the set analysis so that the dates will compare correctly but I'm not sure.

[#2]

Hello Kaushik,

Earlier you helped me with an expression. Seeking your help once more

I'm creating a Historical Sales Trend using set analysis to select dates, until i had two historical dates it was ok, one bar was for the max date & the other for the Remaining one date. But now i've three snapshots.

The user wants to select 5 Snapshot dates in future. The probelm is if i use only list box for the date then the second ba wll show sum of all the remaining 4 dates.

i've also tried generating the 5 dates as:

SnapshotCalendarTemp1:
load Distinct
([Snapshot Date]) as [Snapshot Date1] resident Sales;

SnapshotCalendarTemp2:
load Distinct
([Snapshot Date]) as [Snapshot Date2]  resident Sales;

SnapshotCalendarTemp3:
load Distinct
([Snapshot Date]) as [Snapshot Date3] resident Sales;

SnapshotCalendarTemp4:
load Distinct
([Snapshot Date]) as [Snapshot Date4]  resident Sales;

SnapshotCalendarTemp5:
load Distinct
([Snapshot Date]) as [Snapshot Date5]  resident Sales;

to create 5 separate list boxes & then using the expressions to create the list boxes depending on the selection in the previuos list box, hiding/showing them successively.

But its not working properly

PLz help

Regards

[kaushiknsolanki]

Hi,

   I request you to please create a new discussion on this and also provide the same example in QVW format and describe what you want and what you are trying to do.

  This will help you to get faster solution as well as help others who have similar problem.

Regards,

Kaushik Solanki