topic Do not change the calculated value on selection in QlikView

Do not change the calculated value on selection

Thu, 16 Feb 2017 11:52:08 GMT

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

sunny_talwar — Fri, 17 Feb 2017 12:15:27 GMT

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:

Fri, 17 Feb 2017 12:51:45 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?

sunny_talwar — Fri, 17 Feb 2017 12:54:18 GMT

Try this:

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

Fri, 17 Feb 2017 13:10:20 GMT

It works, very simple.

Thanks