Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.

1 Solution

Accepted Solutions
qliksus
Specialist II
Specialist II

Hi,

Create one more column called Mincure1 amd maxcure1 in the script and dont add it to the inputfield function  and in the list box expression

write something like  =if(getselectedcount(Cure)>=1,mincure,mincure1)

View solution in original post

28 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Can you please describe the purpose of doing this.

   It will help me to understand your problem in detail.

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

Actually "A" is the field in another qvd file and it contians min and max values. Based on this selections i'm loading qvd file.To redecuce the dataset of this qvd file i want to do this.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Sorry but didnt got what you said, can you please describe in detail with example.

   Upload qvw file as well.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

不知道 我理解的对不对 您是想 利用表A的数据  达到和其他qvd文件 同步 计算的目的?

qliksus
Specialist II
Specialist II

Hi,

Create one more column called Mincure1 amd maxcure1 in the script and dont add it to the inputfield function  and in the list box expression

write something like  =if(getselectedcount(Cure)>=1,mincure,mincure1)

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

qliksus,

where i need to add this action =if(getselectedcount(Cure)>=1,mincure,mincure1).

I tried with triggers and also in button action it is not changing.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Kaushik,

Based on this selections i'm genereating one output straight table. In this straight table "A" is column and it contains data (i.e 1 to 100) now the minvalue is 1 and maxvalue is 100. Now the column A contains 1 to 100 data rows. I'm filtering this column at the selectons part. I'm changing the minvalue and maxvalue manually from input box. I'll change minvalue 20 and max value 50. Then the straight table should filter.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Have a look at this.

   Is this what you want.

   Both sheet  describes the two way to achieve this.

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

kaushik,

Sorry....I'm using personal edition. Can please say the procedure.