Ignore Selection In a Text Object

[Anonymous]

I have a very simple text object:

=num(Count(FanID),'#,###')

I'd like to duplicate this and have it ignore selections, so that you can see how many fans you have selected out of the total amount.

For example, as you drill down in the application, I'd like to see that 10/100 people meet the current selection criteria while showing both numbers.

any suggestions would be very helpful!

thank you!

[stigchel · Accepted solution]

To disregard selections use

=num(Count({1} FanID),'#,###')

[Frank_Hartmann]

what about this?

num(Count({1}FanID),'#,###')

[stigchel]

The technique used is called Set Analysis, the 1 stands for

Identifier	Description
1	Represents the full set of all the records in the application, irrespective of any selections made.

More on this topic

Set analysis and set expressions ‒ QlikView