topic Adding Calculated Dimension in QlikView

Adding Calculated Dimension

Fri, 02 Mar 2012 06:10:32 GMT

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.

Adding Calculated Dimension

erichshiino — Fri, 02 Mar 2012 19:48:40 GMT

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

Adding Calculated Dimension

Sat, 03 Mar 2012 04:40:04 GMT

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

Adding Calculated Dimension

deepakk — Sat, 03 Mar 2012 08:09:05 GMT

hi,

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

num(vto) - num(Prob_Report_Date)

Deepak