4 Replies Latest reply: Sep 22, 2015 3:37 PM by Liron Baram RSS

    Quarter variables not holding any data

      Dear QlikComm,

       

      Hey guys, I'm having some difficulty with my quarter variables.

      if I make a table with quarters I get the data fine, but when I define variables to compare the quarters I don't get any data.

       

      My quarters are filled with

      LOAD

      'Q' & Ceil(Month(datum)/3) as  Quarter

      FROM

       

      And I have defined the following variables:

      Let vCurrentQtr = ceil(month(Today())/3);

      Let vPreviousQtr = if(Mod(fabs(vCurrentQtr-1),4)=0, 4, Mod(fabs(vCurrentQtr-1),4));

      let vCurrentQuarterNumber = lookup( 'QuarterCounter', 'DateId', date(today(), 'DD/MM/YYYY'), 't1' );

       

      But if I use the following expression to fill a table I get 0's

      (sum({<Quarter={'$(vPreviousQtr)'}>} HRM_Paginaweergaven))

       

      Does anyone know why that is? Thanks...

      Rob