Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

indicator

LYTD is the ratio of current year actual vs last year actual,i want to create an indicator which will whether ratio is increased or decrease as compared to previous selection.How can we do that

1 Solution

Accepted Solutions

Re: indicator

See this blog post: Replacing images with Geometric Shapes as visual cues


talk is cheap, supply exceeds demand
5 Replies

Re: indicator

See this blog post: Replacing images with Geometric Shapes as visual cues


talk is cheap, supply exceeds demand
vishalwaghole
Valued Contributor II

Re: indicator

He Shweta,

Go to expression definition,

in if statement depending on your expression you can add this images. If you clicked on paste image will

automatically inserted as 'qmem://<bundled>/BuiltIn/arrow_e.png'

-- Regards,

Vishal Waghole

vishalwaghole
Valued Contributor II

Re: indicator

In expression tab u need to set one more property.

for the respective expression u need to set Representation as "Image".

Hope it will work for you.

thornofcrowns
Valued Contributor II

Re: indicator

Thanks for that link!

jsingh71
Valued Contributor

Re: indicator

Modify the below expression as per your fields:

(Sum(Current_Year_Actuals) > Sum(Previous_Year_Actuals),'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

Community Browser