Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
kostiskampouris
Contributor II
Contributor II

Month and year selection

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?

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

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