3 Replies Latest reply: Mar 3, 2012 3:09 AM by Deepak Kurup RSS

    Adding Calculated Dimension

    Arun Goel

      hi,

      I have added calculated dimension to my chart to create a range(i.e 0-30, 30-60 etc.)

      It is working fine in 32 bit Qlikview but when i transfer it to 64 bit, it did't work.

       

      Any particular reason??

      here "vto" is a variable whose value is selected by user by means of a calender.

       

       

       

       

      =if(
      ((vto- Prob_Report_Date)<=30)
      , '0-30', 
      if(
      (((vto- Prob_Report_Date)>30) and ((vto- Prob_Report_Date) <=60))
      , '30-60', 
      
      
      if(
      (((vto- Prob_Report_Date)>60) and ((vto- Prob_Report_Date) <=90))
      , '60-90' ,
      
      
      
      
      if(
      (((vto- Prob_Report_Date)>90))
      , ' > 90', 'none'  
      
      
      )
      )
      )
      )
      
      

       

       

      Thanks in advance.