topic Re: QlikSense Advance Filters in App Development

QlikSense Advance Filters

kmmqlick — Sat, 16 Nov 2024 17:42:26 GMT

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.

Re: QlikSense Advance Filters

GaryGiles — Tue, 15 Dec 2020 11:30:18 GMT

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.

Re: QlikSense Advance Filters

kmmqlick — Wed, 16 Dec 2020 07:13:13 GMT

ThankYou GaryGlies.It is working