topic Re: Set analysis Year range in QlikView

Set analysis Year range

Wed, 17 Dec 2014 11:17:59 GMT

Hi guys,

Can somebody show me on how to write the following condition in set analysis properly?

If(FiscalYear>=2014 and FiscalYear=Year(Today()))

I tried something like this but doesn't seems to yield the result I expected

{$<FiscalYear={">=2014"}, FiscalYear={"=$(=Year(Today()))"}>}

Thank you for your kind attention guys

Regards,

Khairul Anuar Azuddin

Re: Set analysis Year range

Wed, 17 Dec 2014 11:31:30 GMT

hi,

Plz explain,if u want this..

if fiscal year is greater than equals to 2014,then u need to show todays date of year

or as u wrote and in between ..then if the conditions fulfills then what do u want to show.

thanks

sudhanshu shrivas

Re: Set analysis Year range

Wed, 17 Dec 2014 11:47:15 GMT

Hi Sudhanshu Shrivas,

This is what I intended

Sum({$<FiscalYear={">=2014"}, FiscalYear={"=$(=Year(Today()))"}>} Amount)

FiscalYear	Amount
2013	100
2014	200
2015	30

Basically I want to ignore anything prior to 2014, which means say today is the 2014, the amount up would be 200. Hypothetically if today is 2015 it would be 30.

If I write the set analysis like this,

Sum({$<FiscalYear={"=$(=Year(Today()))"}>} Amount)

The set analysis would defy the original condition that I intended in which it would also show the amount prior to 2014.

Thank you for your kind attention.

Regards,

Khairul Anuar Azuddin

Re: Set analysis Year range

consenit — Wed, 17 Dec 2014 12:18:41 GMT

Hello.

There seems to be an extra equal sign. Try this:

=Sum( { $< FiscalYear={">=2014"}, FiscalYear={"$(=Year(Today()))"} > } Amount)

Re: Set analysis Year range

engishfaque — Wed, 17 Dec 2014 13:07:35 GMT

Dear Khairul,

Here is the set analysis,

Sum({$<FicalYear = {'>=2014'}>} Amount)

Kind regards,

Ishfaque Ahmed

Re: Set analysis Year range

Anonymous — Wed, 17 Dec 2014 13:15:59 GMT

Hi Khairul,

Try below:

=Sum( { $< FiscalYear={">=2014"}, FiscalYear={"$(=Year(Today()))"} > } Amount)

=Sum( { $< FiscalYear={">=$(=Year(Today()))"} > } Amount)

Regards

Neetha

Re: Set analysis Year range

gandalfgray — Wed, 17 Dec 2014 14:09:52 GMT

Hi Khairul

Your original condition does not match what you write in your first comment.

You started with the pseudo code

If(FiscalYear>=2014 and FiscalYear=Year(Today()))

(which means FiscalYear 2014 or after (that is 2014,2015,2016 etc) and FiscalYear of today (that is 2014, and in a few weeks 2015)

then you write "the original condition that I intended in which it would also show the amount prior to 2014" - if this is what you want the statement should be written

If(FiscalYear<2014 and FiscalYear=Year(Today()))

anyway

if you want a set statement for the first case it would be:

{<FiscalYear={">=2014","$(=Year(Today()))"}>}

and if you want it for the second case (include prior to 2014) it will be:

{<FiscalYear={"<2014","$(=Year(Today()))"}>}

hope this helps

/gg