topic Re: Input Field values getting change with out inserting in it. in QlikView

Input Field values getting change with out inserting in it.

Sun, 14 Oct 2012 07:17:50 GMT

Hi Community,

I am looking forward to sort the issue I have as follow:

Inserting value in input field changes other existing values in the same inputfield column.

Note: I use it in Straight Table.

I make it as follows:

INPUTFIELD x;

ABC:

LOAD

StoreID,

1 as x;

SQL SELECT *

FROM [Transaction];

Help me out to fix it.

Re: Input Field values getting change with out inserting in it.

IAMDV — Sun, 14 Oct 2012 11:27:05 GMT

Irfan,

Please can you post the sample QVW file? It'll be easy to work with your example.

Thanks,

www.QlikShare.com

Re: Input Field values getting change with out inserting in it.

Sun, 14 Oct 2012 12:46:17 GMT

Hi Deepak,

Please find the attached file.

Re: Input Field values getting change with out inserting in it.

kaushiknsolanki — Sun, 14 Oct 2012 14:44:06 GMT

Hi,

The reason is table x is not connected to your Num table.

Find the updated version.

Hope this will solve your problem

Regards,

Kaushik Solanki

Re: Input Field values getting change with out inserting in it.

Mon, 15 Oct 2012 06:35:00 GMT

Hi Kaushik,

Thanks for the answer ,I find it correct.

Re: Input Field values getting change with out inserting in it.

Mon, 15 Oct 2012 07:43:39 GMT

Hi Kaushik,

I am looking forward for one more solution,

As you know we have Bucket Filter as follows:

Base on the selection on Bucket filter ,the value of x should be overwrite to some specific value

For example:

We have selection on bucket filter on "10 <= x <15"

the vlaues for x should be overwrite to 5.

Please help me out.

Re: Input Field values getting change with out inserting in it.

IAMDV — Mon, 15 Oct 2012 20:22:02 GMT

Irfan,

Please check the IntervalMatch() Function in QlikView Script. You can group your data based on Intervals.

Thanks,