Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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