Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to add user input value along with my count expression (date comparison)

I written some count expression as mentioned below.

=Count({<EMPJOINDATE={"(>=$(vCalcDate)<=$(vToday))"},SECTION= {'*AB-*','*CD-*'}>} DISTINCT EMP_NUMBER)

Along with the above, i want to pass one more condition which is already filled in listbox. ListBox contains number of Sequence values (Days)

Example :

DAYS (ListBOX)
-----
1
2
3
4
5
6
7
8
9
...
...
100


When i select the listbox, then my count automatically should get change. I tried below expression. But, nothing will reflect.

what i want to do..?


Note : i created variable (vUserInput) ==> GetFieldSelections(DAYS)

 

=Count({<EMPJOINDATE={"(>=$(vCalcDate)<=$(vToday) + vUserInput)"},SECTION= {'*AB-*','*CD-*'}>} DISTINCT EMP_NUMBER)

will the syntax is correct...?

Labels (3)
11 Replies
saivina2920
Creator
Creator
Author

How to call or using input box...
if i call input box, will i that variable properly in the rxpressions...?
rubenmarin

Inputbox is just to check variable values. Right-click in sheet-> add object->input box-> add variables to check