Input Field values getting change with out inserting in it.

[#1]

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.

[IAMDV]

Irfan,

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

Thanks,

DV

www.QlikShare.com

[#3]

Hi Deepak,

Please find the attached file.

[kaushiknsolanki · Accepted solution]

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

[#5]

Hi Kaushik,

  Thanks for the answer ,I find it correct.

[#6]

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.

[IAMDV]

Irfan,

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

Thanks,

DV

www.QlikShare.com