topic Re: Month Exclude in QlikView

Month Exclude

master_student — Tue, 13 Dec 2016 10:29:09 GMT

hello Guys,

Hope all is well.

I have a Month of date field that contains months of the year. I would like to display all months except december (because data of that month is not ready yet). I mean to delete december from my graphs and tables.

Here's my expression : =num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}, [Month of date]=,[kp_value]=>} total_subcribers),'# ##0')

Any idea please?

Thanks

Re: Month Exclude

ganeshsvm — Tue, 13 Dec 2016 11:09:17 GMT

Do you want to exclude December month from you data model or you want December bt don't want to show in charts.

and

Please mention which years December you want to exclude

Posting a sample data in excel would be helpful.

Regards

Re: Month Exclude

master_student — Tue, 13 Dec 2016 11:11:49 GMT

I want to excule December from my graphs and not from the data model

Re: Month Exclude

ganeshsvm — Tue, 13 Dec 2016 11:19:34 GMT

so you can modify your exp like this,

num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}, [Month of date]-={"December"},[kp_value]=>} total_subcribers),'# ##0')

Note: [Month of date]-={"December"} - provide exactly value which you have in your data.

Re: Month Exclude

master_student — Tue, 13 Dec 2016 11:31:20 GMT

Thanks. will try and let you know and just another question : if I would like to exclude this month from the list box selection?

Thanks

Re: Month Exclude

master_student — Tue, 13 Dec 2016 11:43:05 GMT

I excluded december from my graphe (year 2015) but the pb is that the other months disappear except the selected month see bellow:

here is my expression :

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}, [Month of date]-={'déc'},[kp_value]=,>} total_subcribers),'# ##0')

Re: Month Exclude

ganeshsvm — Wed, 14 Dec 2016 06:39:17 GMT

if you don't want any selections to affect your chart, try this:

=num(sum( {1<[Year of date]={$(=Max([Year of date])-1)}, [Month of date]-={'déc'}>} total_subcribers),'# ##0')

in both expressions.