topic Re: set analysis with the variable today() in QlikView

set analysis with the variable today()

Mon, 07 Sep 2015 09:44:21 GMT

Hello everyone:)

I need some help with a set analysis.

I include the variable year(today()) in my set analysis. but my problem is that mastercalender. for example my fiscal year starts at 1.10. and not at 01.01.

vtoday = year(today())

sum({<Year={"$(vToday))">}XXX)

it's not perfect working because of my fiscal Year. So what can I Do?

today need to depend on my mastercalender..! I hope some of you have a solution. THANKS:))

Re: set analysis with the variable today()

MK_QSL — Mon, 07 Sep 2015 09:46:25 GMT

vtoday = =IF(Month(today()) < 10, year(today())-1, Year(Today()))

Re: set analysis with the variable today()

senpradip007 — Mon, 07 Sep 2015 09:47:28 GMT

Can you post sample qvw for better solution?

Re: set analysis with the variable today()

Mon, 07 Sep 2015 11:15:14 GMT

thank you now I have an solution but maybe u can help me with an another problem:D

So. I like to have an set analysis with Quarters-value but i would filter only the year.

now, i have a quarter ID but if i take the year i have 4 value for example

2014 Q4 = 47

2015 Q1 = 48

2015 Q2 = 49

2015 Q3 = 50

2015 Q4 = 51

vQuarter = QuarterID

that's not working only if i filter to a Quarter but i don't wanna filter quarter only year...

sum({$<QuarterID = {"$(vQuarter)"}>)XXX

THANKS for the answer