Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
See this blog post: Replacing images with Geometric Shapes as visual cues
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'
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.
Thanks for that link!
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')