topic Replace previous value in listbox after unmark in QlikView

Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 05:41:20 GMT

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.

- 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.

Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 05:55:20 GMT

Hi,

Can you please describe the purpose of doing this.

It will help me to understand your problem in detail.

Regards,

Kaushik Solanki

Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 06:03:02 GMT

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.

Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 06:07:49 GMT

Hi,

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

Upload qvw file as well.

Regards,

Kaushik Solanki

Replace previous value in listbox after unmark

Fri, 24 Jun 2011 06:08:12 GMT

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

Re: Replace previous value in listbox after unmark

qliksus — Fri, 24 Jun 2011 06:18:44 GMT

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)

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 06:48:16 GMT

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.

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 07:39:40 GMT

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.

Re: Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 09:10:24 GMT

Hi,

Have a look at this.

Is this what you want.

Both sheet describes the two way to achieve this.

Regards,

Kaushik Solanki

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 09:16:37 GMT

kaushik,

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

Re: Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 09:25:17 GMT

Hi,

Say for example.

You have a field Called A which has values from 1 to 100. You want user to give min and max he want to see from field A.

Create two variable. Say Var1, Var2. Add input box. Set Var1 as min and Var2 as max.

Create a chart with fild A as dimension and Expression as below.

Sum({<A = {">=$(Var1)<=$(Var2)"}>}1)

Instead of 1 you can have field.

Click ok.

Input min and max from inputbox and see the change in your chart/Table.

Regards,

Kaushik Solanki

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 09:57:06 GMT

kaushik,

Can you please leave that what is the next i'm doing. Please give me the solution for 1st requested post.

Qliksus had given some solution but i not able to do where i need to add that action.

Re: Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 10:01:21 GMT

Hi,

I dont know what logic Qliksus applied but he want you to add that expression in list box.

Create a list box -> select expression (You will find this at the bottom in the list if field) -> Paste the expression there.

Regards,

Kaushik Solanki

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 10:18:58 GMT

Hi,

Qliksus said like this in the script should be as following:

INPUTFIELD MaxCure,MinCure;

Table1:

LOAD Cure,

MaxCure,

MinCure,

MaxCure as MaxCure1,

MinCure as MinCure1

FROM

D:\Examples\TB01_20110624_103856.xls

(biff, embedded labels, table is Sheet1$);

- Then in the list box add field "Cure" and the list box contains the expression tab in this i add the code =if(getselectedcount(Cure)>=1,mincure,mincure1)

- But it is not working for me.

Re: Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 10:23:59 GMT

Hi,

Let me tell you what i understood.

You have a field A which has value from 1-100 and you have a chart say straight table.

Now you want user to input min and max value he want to show from the field a.

i.e if he selects min =10 and max =20, then he should see all values from A field which are in between this min and max in chart.

Am i right..?

Regards,

Kaushik Solanki

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 10:34:59 GMT

Yes by using set analysis i can filter the straight table. As you said i need to take two input variables based on inputs it will filter the straight table.This example i had tried previosly.

- But how can i overcome this task now. I had attached my qvw file in the previous post in that if you add this expression like this.

=if(getselectedcount(Cure)>=1,'A','B')

- It is working fine but if we add fields it is not working..

Re: Replace previous value in listbox after unmark

qliksus — Fri, 24 Jun 2011 10:51:42 GMT

Hi sorry for the late reply what i understood was you have to revert back to the old value eventhough u are changing

the value of field. Say for example u have the field mincure which is a inputfield so u can change that to any value

during selection but when u deselect the initial value should be retained in that case i have created one more

column and have not added to the inputfield so that the initial value will be retained and i have created the

expression which will just change the values when u add it in the list box

Please let me know if i understood u wrongly

Replace previous value in listbox after unmark

kaushiknsolanki — Fri, 24 Jun 2011 10:51:55 GMT

Hi,

I dont understand why you want to go with this expression when you can achieve same with the set analysis.

Regards,

Kaushik Solanki

Re: Replace previous value in listbox after unmark

jagannalla — Fri, 24 Jun 2011 11:02:44 GMT

Qliksus,

what you said is correct. I tried with your code it is not working but when i tried with string value like it is working. I don't know y it is not working with field values.

- I tried like this:

=if(getselectedcount(Cure)>=1,'A','B')

Replace previous value in listbox after unmark

qliksus — Fri, 24 Jun 2011 11:41:13 GMT

jagannalla ,

its working for me in the file u have attached i can attach the file but u cant open that i guess bcoz of the personal

edition So paste your expression i will try here and let u know what u are missing