QlikSense Advance Filters

[kmmqlick]

Hi All,

I am having issues with filter selection. I am giving details in the following images. Please help to resolve the problem. I am having  following fields in the table Customer, sales and InvoiceDate.

Problem: when Daily is selected ->Year selected----> Getting values in Table. But MonthYear selected after Year not getting PY-Sales values.All expression are shown in the below images.

Thanks in Advance.

[GaryGiles · Accepted solution]

Try this for you PYSales Expression:
Sum({<Year={$(vPY)},MonthYear=,Month={$(=concat(Distinct chr(39)&Month&chr(39),','))}>} Sales)

You may need to make some adjustments based of what other field might be filtered or used as dimensions.

[kmmqlick]

ThankYou GaryGlies.It is working