Month and year selection

[kostiskampouris]

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 · Accepted solution]

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]

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

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

[sunny_talwar]

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