Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set analysis with date

Hi everybody

i did this to compare the selections between the selected year and the selected year -1

=Sum({$<YEAR={$(=Only(YEAR))}>}  MONEY))

=Sum({$<YEAR={$(=Only(YEAR)-1)}>}  MONEY))


and it's working ok


But now i have to do the sam expression BUT i have to see the expression from the selected year/month -  1 year


I mean if i select for example 2015 - april i have to see the graphic from 2014 april to 2015 april (in the two expressions) in the other i have to see from 2013 april to 2014 april


Thank you all


Greetings.





5 Replies
Highlighted
Not applicable

Re: Set analysis with date

Hi,

you have to create a numeric field (ex PeriodNum) in load script like this:

ex:

Jan-2013 -> 01

Feb-2013 -> 02

Mar-2013 -> 03

Apr-2013 -> 04

...


and then use this new field in set analysis:


=Sum({$<PeriodNum={"<=$(=(Only(PeriodNum))) >=$(=Only(PeriodNum)-12)"}>}  MONEY))

=Sum({$<PeriodNum={"<=$(=(Only(PeriodNum)-12)) >=$(=Only(PeriodNum)-24)"}>}  MONEY))


Highlighted
Specialist III
Specialist III

Re: Set analysis with date

I agree with Mario, you have to make sure you date format is something that is taken as a number/date

I personally prefer to use the starting date of the month instead of using only the sequential number, that makes it a little easier to work with on the long run

date(makedate(year,month),'MMM-YYYY') as MonthYear

Highlighted
Not applicable

Re: Set analysis with date

Hi

I'd like to not touch the script. The app is very big and it takes 30 minutes to reload it.

I already have a field that is  year*12 + month.i could use that. they are numbers.


Not applicable

Re: Set analysis with date

isnt there a date function to do this?

Highlighted
Not applicable

Re: Set analysis with date

try with addmonths() function.

ex.

addmonths(YourDataField,12)

addmonths(YourDataField,-12)