Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kalyandg
Contributor II

Status

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  

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Status

Hi.

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

Is that what you want ?

3 Replies
whiteline
Honored Contributor II

Re: Status

Hi.

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

Is that what you want ?

kalyandg
Contributor II

Re: Status

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

whiteline
Honored Contributor II

Re: Status

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

Community Browser