Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (1)
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