Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do not change the calculated value on selection

Dear Community,

With the count-command i Count reports.

This value changes in the selection of building blocks. Does anyone know a command to Keep this value constant?

regards

4 Replies
sunny_talwar

Use set analysis

If you want to ignore all selections

Count({1} Report)

If you want to ignore specific fields

Count({<[Building Blocks]>} Report)

Read about set analysis here:

A Primer on Set Analysis

Set Analysis: syntaxes, examples

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?

sunny_talwar

Try this:

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

Not applicable
Author

It works, very simple.

Thanks