Adding Calculated Dimension

[#1]

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.

[erichshiino]

Hi,

I'm not sure, but it can be a date problem and not a system problem.

What happens if you add Prob_Report_Date in the straight table and (vto- Prob_Report_Date) as an expression?

You can also try this calculated dimension:

=

aggr(

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'

)

)

)

)

,Prob_Report_Date)

Regards,

Erich

[#3]

its still not working...:(...

[deepakk]

hi,

Make sure the format of the both field and variable is same. Make both numeric

num(vto) - num(Prob_Report_Date)

Deepak