topic Month FIeld selection issue in QlikView

Month FIeld selection issue

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

I have Month and Year field selection in my dashboard :

When I select Year and all months it gives me wrong result

but

when I select Year and No selection in Month filter then it gives me correct results.

What could be the possibility for this error, experts can you please let me know?

Chanty4u — Fri, 23 Feb 2018 07:37:46 GMT

can you share the screen shot of Datamodel?

Chanty4u — Fri, 23 Feb 2018 07:38:30 GMT

how it linked with the master calnedar?

deepali_more — Fri, 23 Feb 2018 08:42:56 GMT

Both the values are coming from same table

arvind_patil — Fri, 23 Feb 2018 08:52:18 GMT

Hi Deepali,

I think your month field mapped wrongly against year.

Kindly cross check with below table format.

Data_Source , year ,month

- - -

Thanks,

Arvind Patil