topic Re: Status in QlikView

Status

kalyandg — Tue, 27 Nov 2012 10:27:51 GMT

Dear All,

I have a issue in status for excess, onlevel and depreciation, while i select excess from drop down list, it should about 100%, i know that we can solve this using visual cues, but i need to do this in script.

for excess i have to give a condition that value which is >1 ----- 'Excess'

for onlevel =1 ----------------- 'Onlevel'

for depreciation <1 ------------------ 'Depreciation'

Please help me to solve this issue, Excess(more than 100%), onlevel(100%) and depreciation(less than 100%)

Thanks in Advance,

Kalyan.D

Re: Status

whiteline — Tue, 27 Nov 2012 10:52:18 GMT

Hi.

If(value>1, 'Excess', If(value=1, 'Onlevel', 'Depreciation'))) as ListValues

Is that what you want ?

Re: Status

kalyandg — Wed, 28 Nov 2012 04:23:35 GMT

hi white,

the expression you have replied is correct, but for me it showing less than and more than 100% values when i select onlevel, i dont know what is the problem. please help.

Thanks,

Kalyan

Re: Status

whiteline — Wed, 28 Nov 2012 06:32:50 GMT

Could you provide a sample file or at least your load script where you've used the above string ?