Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
its still not working...:(...
hi,
Make sure the format of the both field and variable is same. Make both numeric
num(vto) - num(Prob_Report_Date)
Deepak