Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Input Field values getting change with out inserting in it.

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.

1 Solution

Accepted Solutions

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

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

6 Replies
Luminary
Luminary

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

Irfan,

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

Thanks,

DV

www.QlikShare.com

Not applicable

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

Hi Deepak,

Please find the attached file.

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

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

Not applicable

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

Hi Kaushik,

  Thanks for the answer ,I find it correct.

Not applicable

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

Hi Kaushik,

           I am looking forward for one more solution,

                  

     As you know we have Bucket Filter as follows:

Capture.JPG

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.

Luminary
Luminary

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

Irfan,

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

Thanks,

DV

www.QlikShare.com

Community Browser