topic Re: Calculated Dimension in QlikView

Calculated Dimension

krishnacbe — Wed, 10 Oct 2012 12:47:05 GMT

Hi,

I have used calaculated dimension in a straight table. If i select some values they appear in table. If i click on the selected item the selection should be removed, as this is a Qlikview functionality. But it is not working.

Please some one help me to fix this.

Thanks in Advance.

Regards

Krishna S

Re: Calculated Dimension

martinpohl — Wed, 10 Oct 2012 12:57:14 GMT

Hello,

did you use the same field in the calculation / dimension?

For example whe you are using

if(aggr(sum(value),articlenumber)>0,articel)

this will happen.

It only works fine when you are using

if(aggr(sum(value),article)>0,articel)

Regards

Re: Calculated Dimension

krishnacbe — Wed, 10 Oct 2012 13:02:58 GMT

Hi,

Thanks.

This is my sample code.

if(@ADFlag='Yes', if(IsNull(@CompletionDate_AD)=-1, JobNumber),JobNumber)

If I select first time Job number every thing is ok, if i select it second time selection is not removed.

Regards

Krishna S

Re: Calculated Dimension

krishnacbe — Wed, 10 Oct 2012 13:06:31 GMT

Hi,

Can any one please confirm me, if we use calculated dimension we can't use normal or wild card search.

For example:

I have a Field A. I have a Expression as =if(b=0,A).

I have enabled drop down selection for the column A in Straight table. If i type something nothing is displayed in the drop down list box.

Thanks.

Regards

Krishna S