Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

neena123
New Contributor II

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

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?

1 Solution

Accepted Solutions

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

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,

Regards,
Prashant Sangle
3 Replies
iktrayanov
Contributor III

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

iktrayanov
Contributor III

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

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.

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,

Regards,
Prashant Sangle
Community Browser