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: 
Not applicable

How to connect two input boxes?

Hi,

I have attached a sample file now.

Here is little description of the file.

It contains 5 fields, out of these 5 three of them are Comments Posted (CP) in 4 weeks, 26 weeks and in 52 weeks.

Created Input boxes for CP 4 weeks and 26 weeks. These input boxes have two variables each (signs and values). Later I will include for 52 weeks as well.

I want to create a table chart based on these input boxes.

Expression should fulfill all (and) the conditions of the input boxes. For example I want expressions for 4 weeks and 26 weeks like

"CP in 4 Weeks >= 4 and CP in 26 Weeks <=10"

How can I write an IF condition for expression which fulfull the both input boxes conditions.

Can someone write these expression?

Please let me know if something is not clear.

Thanks,

TA

2 Replies
Anonymous
Not applicable
Author

check attached...

Not applicable
Author

Hi Aadil,

Thanks for your reply. Your solution was very helpful and was a very good starting point to solve my problem. I got was looking for. However the equal sign in the drop down is not working. Rest all ">,<,<=,>=,<>" all are working fine except "=" sign. Any clue why equal sign is not working?

Thanks once again 🙂

TA