Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search string with variables/functions

Is it possible to make a selection based on a function or a calculation in a variable?

lite: < avg(salesid) ?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

It is possible,

You can create a new variable in the Settings menu, Variable Overview, add a new one, say, vTotalCustNo

=COUNT(DISTINCT CUSTOMER_ID)


And then get it

$(vTotalCustNo)


Is that what you mean?

View solution in original post

2 Replies
Miguel_Angel_Baeyens

It is possible,

You can create a new variable in the Settings menu, Variable Overview, add a new one, say, vTotalCustNo

=COUNT(DISTINCT CUSTOMER_ID)


And then get it

$(vTotalCustNo)


Is that what you mean?

Not applicable
Author

Yes that was exactly what i wanted thank you Smile