topic Re: Month and year selection in QlikView

Month and year selection

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

Hello everyone,

I have an issue that confuses me a lot.

From a view I upload data in qlikview.The first field is the trasaction_date,I have created three listboxes :

1st the transaction date
2nd the month of the transaction date as an expression month(transaction_date)

3rd the year of the transaction date as an expression year(transaction_date)

The problem is that when I chose fro example February from month's listbox and then I try to choose the year from the year listbox ,

after the selection of the year the month field selection dissapears.Tha same happens the other way arround.

What am I missing here ?Can someone please help?

sunny_talwar — Thu, 08 Feb 2018 16:53:53 GMT

I would suggest you to create these filters in the script

LOAD trans_date,

Month(trans_date) as trans_month,

Year(trans_date) as trans_year

....

From ...;

and then use the new fields as your filters

kostiskampouris — Fri, 09 Feb 2018 09:30:20 GMT

Hello Sunny ,thank you for your response,works great.

Can you please explain what was the problem in my solution ?

sunny_talwar — Sun, 11 Feb 2018 01:25:41 GMT

I am not entirely sure why it behaves this way, but in general its always a good idea to create a field in the script whenever possible