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: 
jagannalla
Partner - Specialist III
Partner - Specialist III

Replace previous value in listbox after unmark

Hi,

- I have a 3 fields(cure,MinCure, MaxCure) and taken i a table box. MinCure & MaxCure are INPUTFIELDS.

- In the listbox i add Field  "Cure" and Expressions with MinCure,MaxCure with presentation WindowsCheckBoxes.

Capture.PNG

- Now when i check "A" in listbox and i will change the value of MinCure 1 with 10(MinCure is inputfield). This will replace in the field Min with 10 of listbox of A row.

- But when i uncheck "A" i want to appear old value 1 under min of A row.

I'm attaching sample qvw file also for your reference.

How can i do this. Is it possible to do.

28 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

qliksus,

Thanks a lot it's working for me also. I don't know how it is working now i just recreated everything in my file after seeing your last post.

Great work for me today.

qliksus
Specialist II
Specialist II

Buddy then mark my answer as correct answer

qliksus
Specialist II
Specialist II

hi Solanki,

Can u please help me in the tread i have created  http://community.qlik.com/thread/30200

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Qliksus,

I need some more help from you.

- Previously what we did is working fine.

- But little bit modification i need.

- Now when i check "A" in listbox and i will change the value of MinCure 1 with 10(MinCure is inputfield). This will replace in the field Min with 10 of listbox of A row.

- But when i uncheck "A" i want to appear old value 1 under min of A row. Upto here we got the solution.

- Again If i check "A" i want to see old value 1 only.

How can we do this...

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

kaushik,

- Previously you have given the set analysis code like this.. Sum({<A = {">=$(Var1)<=$(Var2)"}>}1) .
- How can i use fields in the place of variables in the above code.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   If you replace variable with field it might not work.

   The reason is field may have multiple values where as variable have only one value, thus variable can be comapred with a field.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Ok kaushik Thanks a lot. Is there any solution for which i asked qliksus.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   At the moment i dont know, but i will try to achieve that.

   Will let you know if i found the solution.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Ok kaushik...