error in the calculated dimension

manjunaths — Wed, 25 Nov 2020 16:16:04 GMT

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)))))))

Re: error in the calculated dimension

tresB — Mon, 19 Nov 2018 05:38:19 GMT

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

Re: error in the calculated dimension

jonathandienst — Mon, 19 Nov 2018 06:15:52 GMT

What error are you getting?
Its hard to help you without knowing how vSelDate and vMaxDate are defined.
A sample would help.

topic Re: error in the calculated dimension in QlikView

error in the calculated dimension

Re: error in the calculated dimension

Re: error in the calculated dimension