Set Analysis Question.

[MuraliPrasath]

Hi,

I've a Expression like this in Pie Chart.

sum({1<ShipmentStatus={'COMPLETED'}, Day={"=date($(vToday))"}>}DeliveredQty)

My question is, I have used '1'.  It should be ignoring ALL selections except for what I specified.  but if I select the CarFamily(this is the deminsion for Pie Chart)  it changes.

[jonathandienst]

Ok, so its not the variable. I suggest that you post your qvw or at least a sample illustrating the problem.

BTW - your variable should be defined:

LET vToday = Num(Today(1)));

(The Date() function here does nothing)

[MuraliPrasath]

Hi,

Please help me here is my example Qvd and Spreadsheet.

Correct my Pie-Chart Expression. I don't need any selections. Pie-chart should ignore all the selections on the dashboard.

[MuraliPrasath]

Hi Vimlesh,

Pls see below, I've uploaded the Qvw and flatfile. Pie-Chart should ignore all the selections on the dashboard.

Thanks in advance.

[sasiparupudi1]

May be try

sum({1<ShipmentStatus={'COMPLETED'}, Date={"=($(vToday))"}>}DeliveredQty)

[MuraliPrasath]

still no luck !!

[#7]

Hi Murali,

you are using Day rather than a date field in your set analysis, which is causing you problems.

Use

sum({1<ShipmentStatus={'COMPLETED'}, DATE={"$(=date(vToday))"}>} DeliveredQty)

and just an FYI you have no data for the today set in the example, you nee dot go back to 23rd July to show some data

hope that helps

Joe

[sasiparupudi1 · Accepted solution]

Hi

I am getting the following output when I use the expression

sum({1<CarFamily=,DeliveredQty=,DistChannel=, ShipmentStatus={'COMPLETED'}, Date={"=date($(vToday),'MM/DD/YYYY')"}>}DeliveredQty)

and the pie chart does not change with the selections.Is this what you are expecting to see for todays date?

[#9]

FYI 'Date' isn't a field in the data model so that section of the set analysis isn't doing anything.

So you are actually getting all Completed QTY for the entire data set, not all Completed QTY for today

Joe

[Anonymous]

I like Joe's answer. If you have an actual shipment date to use for DATE, this works perfectly.