topic Re: Ignore selections in QlikView

Ignore selections

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Ignore selections

sunny_talwar — Tue, 18 Jul 2017 12:26:03 GMT

Change your variable to this

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

Re: Ignore selections

tresB — Tue, 18 Jul 2017 12:28:55 GMT

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')

Re: Ignore selections

surajap123 — Tue, 18 Jul 2017 12:34:02 GMT

Thanks Sunny