Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding Calculated Dimension

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.

3 Replies
erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

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

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

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

num(vto) - num(Prob_Report_Date)

Deepak