topic Re: Measuring Against Target in QlikView

Measuring Against Target

dmac1971 — Tue, 24 Mar 2015 10:35:28 GMT

See sample QV attached. I have everything working in my main QV report however want to measure performance against target, this is easy enough but I don't want the YTD filter to filter the table, ie I want to see all countries, their sales, even if zero, against target.

Selecting YTD filter allows me to see target YTD, and deselecting allows me to see full year target, this is perfect, I just don't want any of the dimensions on this sheet of the report to be changed by the YTD filter?

Dmac

Re: Measuring Against Target

ramoncova06 — Wed, 25 Mar 2015 03:05:35 GMT

look this thread up ignore all selections except for some selected columns, if I understood your request correctly this will work

Re: Measuring Against Target

Anonymous — Wed, 25 Mar 2015 03:56:46 GMT

Hi, In the attached file I only changed one chart to save time but I think it shows you exactly how to achieve what you need.

First you need to create an alternate state by going to you document settings and name the alternate state such as Alt1 for this example.

Then in you list box for YTD change the alternate state to Alt1.

In your chart expressions add to the set analysis YTD_Flag =[Alt1]::YTD_Flag for every function.

Re: Measuring Against Target

Anonymous — Wed, 25 Mar 2015 04:35:09 GMT

Hi ,

I checked the attached application, If i have understood your issue then here is the solutions for it

you can go to Chart Object Properties>Presentation> uncheck Supress Zero Values and uncheck Supress Missing

And Chart Object Properties>Dimension>Check Show All values

And if you want you can supress null values from your dimension if you want(I noticed there is null value in the Country dimension)

regards,

Bhagirath