Ignore selections

[surajap123]

Hi All,

I have 2 fact table that i concatenated. In front end i want to show data of both table in individual straight table, so i am using flag in the expression.

The field Stock is only in Wareshouse table, so I don't want Sales straight table to react to selections on Stock field. , so used Stock= in set analysis.

However the data is still filtered because the Date field is not in Wareshouse table, and vMaxDate variable returns null when we do selection on Stock field.

Sum({<Date = {'$(vMaxDate)'},DataSet = {'SALES'},Stock=>}SoldQty)

vMaxDate contain--> =Date(max(Date),'DD/MM/YYYY')

Please help!

[sunny_talwar · Accepted solution]

Change your variable to this

=Date(max({<Stock>}Date),'DD/MM/YYYY')

[tresesco]

You need to put set analysis field ignorance in the variable definition as well. Try variable definition like:

=Date(max({<Stock>}Date),'DD/MM/YYYY')

[surajap123]

Thanks Sunny