topic Re: indicator in QlikView

indicator

Tue, 08 Jul 2014 09:07:33 GMT

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

Re: indicator

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:08:34 GMT

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

Re: indicator

VishalWaghole — Tue, 08 Jul 2014 10:07:23 GMT

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

Re: indicator

VishalWaghole — Tue, 08 Jul 2014 10:10:10 GMT

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.

Re: indicator

ThornOfCrowns — Tue, 08 Jul 2014 10:11:55 GMT

Thanks for that link!

Re: indicator

jsingh71 — Tue, 08 Jul 2014 10:13:01 GMT

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')