Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolgath
Creator
Creator

Can i add a variable to a Count()?

I have : 

I have a field "vehicleStatus" that has values from '0' to '12'.

 

And I isolated the '0' as a count being "Sold Cars"

I did:
COUNT({<vehicleStatus-={0}>} vehicleStatus)

 

Now I have 2 variables, that i will use so the user can input a min value and a max value to create a range.

I have variables : "vMinCarsSold" and "vCarsSoldMax". 

 

My question is how do I join them togheter so I have for example this output:

Min input: 10
Max input: 20

output = all values in between 10 and 20.

I have tried some expressions but no luck..

 

Labels (5)
1 Solution

Accepted Solutions
pedrobergo
Employee
Employee

Hi @Nolgath 

You can try this:

COUNT({<vehicleStatus={"<=$(vMinCarsSold)>=$(vMinCarsSold)"}>} vehicleStatus)

 

[],

Pedro

View solution in original post

2 Replies
pedrobergo
Employee
Employee

Hi @Nolgath 

You can try this:

COUNT({<vehicleStatus={"<=$(vMinCarsSold)>=$(vMinCarsSold)"}>} vehicleStatus)

 

[],

Pedro

Nolgath
Creator
Creator
Author

Thank you!