Filter pane Issue in Qlik Sense

[msbhuvanesh003]

Dear Experts,

Platform: Qlik Sense

I have an issues in Filter pane. I have 2 years data with me (2017; 2018). While selecting the single year the result showing correct only. But the issue is when I select both years the result showing from 2018 year.

Ex:

2017 ………….. 500

2018 ………….. 400

When I select year 2017 result is 500

When I select year 2018 result is 400

While selecting both year 2017 and 2018 result should be 900

But the actual result while selecting both year in filter pane is 400 (result of 2018)

Please help me for this.

the same happens in all the sheets.

[rittermd]

What is the result when you don't select anything?  It should be 900 as it should be displaying all data that was loaded.

[msbhuvanesh003]

it should be current yer value like 400 (result of 2018)

[Anonymous]

Hi Bhuvaneshwaran,

Try to use Auto generated Calendar in your load script and use the "FieldName.Year" field from the list.

Hope this helps.

Thank you!

Best Regards,

Sumit K

[msbhuvanesh003]

my data field name is year only.

but not working properly.

i have above said issues.

[Anonymous]

Hi Bhuvaneshwaran,

If you have date field then convert it into Year by using below expression and try to use this field in your Filter pane:

Year (Date_FieldName)

See if this helps.

Best Regards,

Sumit K