topic Re: Do not change the calculated value on selection in QlikView

Do not change the calculated value on selection

Fri, 17 Feb 2017 07:13:35 GMT

Love Community,

I count reports together with the Count-Command.

This value changes when blocks are selected. Does anyone know a command to Keep this value constant?

regards

dsharmaqv — Fri, 17 Feb 2017 11:34:59 GMT

Use Set analysis

lFor example If you want month selection should not make any impact on your calculation then

Count({$<[MONTH]=>} [Product])

sdmech81 — Fri, 17 Feb 2017 11:47:39 GMT

Say like:

=count({1<>}yourfield)

Put 1 inplace of $ n try..

Sachin

sdmech81 — Fri, 17 Feb 2017 11:48:32 GMT

Or if u wan tht it should nt change based on particular attribute selection then try deepaks one

Sachin

Fri, 17 Feb 2017 12:53:16 GMT

That's right. It works, if I use this command with one field.

My example:

Count({1} [QV Report])

But I like working with set analysis like this:

Count(DISTINCT{1} {$<KPI = {'100_01', '100_02'}>}WERTMENGE)

Why doesn't work the additional function {1} with this set analysis? Do you have a solution?

dsharmaqv — Fri, 17 Feb 2017 12:58:59 GMT

try this

Count(DISTINCT {1<KPI = {'100_01', '100_02'}>}WERTMENGE)

Count(DISTINCT {<KPI = {'100_01', '100_02'},[MONTH]=>}WERTMENGE)

also you can Detach your object as well

or set a new state

dsharmaqv — Fri, 17 Feb 2017 12:59:39 GMT

Also please donot create duplicate thread