Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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".
Thank you very much
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)
Sorry, my bad
Sum({<[Fecha Contable] = {"=Year(Only({1}[Fecha Contable])) = 2014"}>} Euros)
Thank very much, it worked
Cheers