Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

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
Master II
Master II

Hi.

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

Is that what you want ?

View solution in original post

3 Replies
whiteline
Master II
Master II

Hi.

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

Is that what you want ?

kalyandg
Partner - Creator III
Partner - Creator III
Author

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
Master II
Master II

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