topic I can't seem to get myText Object Image Conditional Expression right. in QlikView

I can't seem to get myText Object Image Conditional Expression right.

neena123 — Thu, 20 Mar 2014 15:56:14 GMT

Currently I have a red arrow and green arrow but I do not want both of them showing. I want the red arrow to show when the current year is greater than the previous year 3+ Turnaround Days. I have the 3+ Day status in a text object as well and would like the arrow to pop up next to with the proper color. I downloaded a red and green arrow from the internet. I know I have to create a IF statement then <> sign between the two year values but how do I write in the expression for the arrows to show?

Update: Here is the expression I am putting under the conditional option in the layout tab of the text object properties.

if(count({$<[Ship Year] = { $(=Year(today()))}, [Turnaround Days]={'>2'}, [Facility]={'Alpharetta'}, [Status]={'Shipped'}>}distinct [Unique Order Key])/count({{$<[Ship Year]={$(=Year(today()))}, [Facility]={'Alpharetta'},[Status]={'Shipped'}>}Distinct [Unique Order Key])

(count({$<[Ship Year]={$(=Year(today()))-1)}, [Turnaround Days] ={'>2'}, [Facility]={'Alpharetta'},[Status] = {'Shipped'}>}distinct [Unique Order Key])/ count ({$<[Ship Year] = { $ (=Year(today())-1)}, [Facility]={'Alpharetta'}, [Status]={'Shipped'}>}Distinct [Unique Order Key]),'IMAGE'))

How do I incorporate my downloaded arrows to the "IMAGE" part?

Re: I can't seem to get myText Object Image Conditional Expression right.

iktrayanov — Thu, 20 Mar 2014 16:18:22 GMT

You may want to check this out.

Geometric shapes.qvw

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/13/replacing-images-with-geometric-shapes-as-visual-clues

Re: I can't seem to get myText Object Image Conditional Expression right.

iktrayanov — Fri, 21 Mar 2014 15:17:42 GMT

Try this.

Replace the 'Image' part with the path to your image like 'C:\images\image.jpg'

then go to the Expression tab in your chart and change the representation to image

Regards,

Ivan

Re: I can't seem to get myText Object Image Conditional Expression right.

PrashantSangle — Fri, 21 Mar 2014 15:27:48 GMT

Hi,

There is mistake in your closing brackets,

I made changes in your expression as follow

try this

=if((count({$<[Ship Year] = { $(=Year(today()))}, [Turnaround Days]={'>2'}, [Facility]={'Alpharetta'}, [Status]={'Shipped'}>}distinct [Unique Order Key])/count({{$<[Ship Year]={$(=Year(today()))}, [Facility]={'Alpharetta'},[Status]={'Shipped'}>}Distinct [Unique Order Key]))

(count({$<[Ship Year]={$(=Year(today()))-1}, [Turnaround Days] ={'>2'}, [Facility]={'Alpharetta'},[Status] = {'Shipped'}>}distinct [Unique Order Key])/ count ({$<[Ship Year] = { $ (=Year(today())-1)}, [Facility]={'Alpharetta'}, [Status]={'Shipped'}>}Distinct [Unique Order Key])),'IMAGE')

and paste your image path in 'IMAGE'

Regards,