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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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