Help with an expression

[Anonymous]

HI everyone.

I have a file with different dates (day/month/year) of 2011, 2012, 2013, and so on. and in the same file i have sales volumen. i want to build a chart that shows only data of on specific fix year despite of the year value the user chooses. Can some one be so kind to help me?

Thanks in advance.

[Anonymous]

This one Sum({<[Fecha Contable] = {"=Year([Fecha Contable]) = 2014"}>} Euros) worked better, but when i choose a different other than 2014, what i got is a message saying that "this chart is not displayed because it contains only negative or zero values".

[Anonymous]

Thank you very much

[swuehl · Accepted solution]

I think Sunny is right that your field is a date field, and this is your format: day/month/year ?

It would be good to create a calendar from your date field, using QlikSense date and time functions in your script, like

...

Year([Fecha Contable]) AS Year,

Month([Fecha Contable]) as Month,

...

Then what I suggested above should just work fine, if you clear selections on the fields the user selects in:

=Sum({<Year = {2013}, [Fecha Contable], Month >} Sales)

[sunny_talwar]

Sorry, my bad

Sum({<[Fecha Contable] = {"=Year(Only({1}[Fecha Contable])) = 2014"}>} Euros)

[Anonymous]

Thank very much, it worked

Cheers