Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

msbhuvanesh003
New Contributor II

Filter pane Issue in Qlik Sense

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.

5 Replies
rittermd
Honored Contributor

Re: Filter pane Issue in Qlik Sense

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
New Contributor II

Re: Filter pane Issue in Qlik Sense

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

sumitkulkarni
New Contributor III

Re: Filter pane Issue in Qlik Sense

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
New Contributor II

Re: Filter pane Issue in Qlik Sense

my data field name is year only.

but not working properly.

i have above said issues.

sumitkulkarni
New Contributor III

Re: Filter pane Issue in Qlik Sense

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

Community Browser