Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do not change the calculated value on selection

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

6 Replies
dsharmaqv
Creator III
Creator III

Use Set analysis

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

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

sdmech81
Specialist
Specialist

Say like:

=count({1<>}yourfield)

Put 1 inplace of $ n try..

Sachin

sdmech81
Specialist
Specialist

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

Sachin

Not applicable
Author

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
Creator III
Creator III

try this

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

Or

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

also you can Detach your object as well

or set a new state

dsharmaqv
Creator III
Creator III

Also please donot create duplicate thread

Do not change the calculated value on selection