Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
manjunaths
Contributor II
Contributor II

error in the calculated dimension

Hi All,

I am getting error in the following calculated dimension. Need help to resolve.

In the following dimension,

B1=45

B2=90

B3=120

B4=180

B5=360

=if((($(vSelDate)-$(vMaxDate))>=0 AND ($(vSelDate)-$(vMaxDate))<=$(vB1)),'Range 1 : 0 - ' & $(vB1),
if((($(vSelDate)-$(vMaxDate))>=$(vB1)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB2)),'Range 2 : ' & ($(vB1)+1) & ' - ' & $(vB2),
if((($(vSelDate)-$(vMaxDate))>=$(vB2)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB3)),'Range 3 : ' & ($(vB2)+1) & ' - ' & $(vB3),
if((($(vSelDate)-$(vMaxDate))>=$(vB3)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB4)),'Range 4 : ' & ($(vB3)+1) & ' - ' & $(vB4),
if((($(vSelDate)-$(vMaxDate))>=$(vB4)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB5)),'Range 5 : ' & ($(vB4)+1) & ' - ' & $(vB5),
if((($(vSelDate)-$(vMaxDate))>=$(vB5)+1),'Range 6 : ' & '> ' & ($(vB5)+1)))))))

2 Replies
tresesco
MVP
MVP

It would be easier for us to debug if you could share your app with sample data (if data security is a concern).

jonathandienst
Partner - Champion III
Partner - Champion III

What error are you getting?
Its hard to help you without knowing how vSelDate and vMaxDate are defined.
A sample would help.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein