SET ANALYSIS question

[sridhar_sigired]

Hello,

By default my chart is showing today's data, whereas if user select any product the historical data of that particular product need to display. Suggestion please.

Thanks

[PrashantSangle]

Hi,

Check your set analysis,

In your set analysis have you comparing date= today()

Post your set analysis/Expression.

Regards

[sunny_talwar]

You will need to provide some more details before somebody here can help. What is your current expression? Can you share some sample data?

Best,

Sunny

[Gysbert_Wassenaar]

I suggest you create another chart that shows the historical product data. This chart should get a conditional display expression (on the Layout tab) to show/hide the chart as needed. If the chart should show only when only one product value is selected the conditional expression would be something like =if(GetSelectedCount(Product)=1,1,0)

[tyagishaila]

to solve this issue please provide more information regarding issue.

To get result based on current selection use $ in your expression.

[sridhar_sigired]

Sorry for incomplete information.

I wrote expression like

Sum({$<Date={Today()}>}Sales)

Whereas based on product selection, need to show historical sum of sales for that product. Means except today sales of that product.

Thanks gwassenaar. I will try this way too.

[sunny_talwar]

May be this:

Sum({<Date = {"$(=If(GetSelectedCount(Product) > 0, '<' & Today(), Today()))"}>} Sales)

[mustafaelryah]

Try this :

Sum({$<Date -= {Today()}>}Sales)