Calculated Dimension

[krishnacbe]

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

[martinpohl]

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

[krishnacbe]

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

[krishnacbe]

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