Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression showing all for one person

Hello again,

i got a expression:

Count ({<[KAT samo slova]={S}>} CUSTACCOUNT)

This expression shows me the number of partners(with KAT S) for one employee. When i select a Date the number changes to "only active" buyers(Partners that bougth in the selected range).

Question: How can i have an "active buyer" and "total partners"(does NOT change with entering Date) column?

"ALL" does not work, because it gives me then the number of all Partners in the system(it ignores my dimension employee).

Any idea?

greetings,

Kristian

1 Solution

Accepted Solutions
adhudson
Creator II
Creator II

Hi Kristian,

     Try this one.

     Count ({<[KAT samo slova]={S}, Date_Column=>} CUSTACCOUNT)

     If you add the highlighted string in the expression, all the date selections will be ignored.

     Hope this helps.

Regards

Andrew Hudson

View solution in original post

3 Replies
sujeetsingh
Master III
Master III

Hi,

It seems the issue with set analysis expression..what about your expression is it OK.

And can u plz elloberate

adhudson
Creator II
Creator II

Hi Kristian,

     Try this one.

     Count ({<[KAT samo slova]={S}, Date_Column=>} CUSTACCOUNT)

     If you add the highlighted string in the expression, all the date selections will be ignored.

     Hope this helps.

Regards

Andrew Hudson

Not applicable
Author

Thank you very much.

so the bolded info behind the "," means something like "dont react on this parameter"?