Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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!