topic How to show specific values in chart in QlikView

How to show specific values in chart

kfir1987 — Mon, 17 Sep 2018 12:00:40 GMT

Hi All,

I`m trying to create new chart but I want to show only key models in the chart ! but on the other hand I want to give to the user the ability to select model in the filter view.

I will give an example:

When no selection has made, I want to show by default the machines models: X,Y,Z

but when the user made a T machine model , I want to show only the model machine T.

I used the line chart:

group field is "Time"

Line field is "Model"

measure is

((sum( Aggr(sum( distinct [Duration]),[Machine Job])))/

($(vUtilizationTotalTime)*count( distinct [Machine number])))

I dont want to use the function getCountSelected - it makes issues when selection made.

the only way that I can think about is Set Analysis, it works in some cases (when I applied it on the dimensions) but when the user try to select some value in model filter the selection didn`t change .

any suggestion ?

Thanks

Re: How to show specific values in chart

Anonymous — Mon, 17 Sep 2018 12:14:55 GMT

what is your issue using "getselectedcount"? you want the models X;Y;Z when no selection is done.

Maybe you may use a test for explizit naming of models?

if (match(getfieldselections,Line), 'T','other models except X;Y;Z') > 0,

((sum( Aggr(sum( distinct [Duration]),[Machine Job])))/

($(vUtilizationTotalTime)*count( distinct [Machine number])));

((sum( Aggr(sum( distinct [Duration]),Line={'X','Y','Z'},[Machine Job])))/

($(vUtilizationTotalTime)*count( distinct [Machine number])))

Re: How to show specific values in chart

kfir1987 — Thu, 20 Sep 2018 07:26:45 GMT

When i`m doing another selection the previews selection change for some reason.