topic Re: Search is getting Cleared in QlikView

Search is getting Cleared

sjhussain — Tue, 09 Sep 2014 13:43:22 GMT

We have two buttons - One is to trigger a search from an input box and the other is for date search (From, To) in two date calenders.

When we do the Search from the Input box it populates the table correctly displaying results related to the search.

The problem we are facing is that when we action the Date Search Button - it clears the all the selection and shows the dates for all the records rather than keeping the input box selection and then filtering the Dates.

Will appreciate if someone can assist us in this regards.

Thanks

Re: Search is getting Cleared

Gysbert_Wassenaar — Tue, 09 Sep 2014 13:46:03 GMT

If you make a selection that contradicts another selection then the former selection will be cleared.

Re: Search is getting Cleared

sjhussain — Tue, 09 Sep 2014 13:53:51 GMT

Gysbert,

Thanks for your response. I think there is no contradiction in the selections. One is for fieldA and the other one is for DateFields. How can there be a contradiction?.

Re: Search is getting Cleared

Gysbert_Wassenaar — Tue, 09 Sep 2014 13:59:41 GMT

Perhaps there are no values in fieldA that have records with matching values in the date fields.

Re: Search is getting Cleared

sjhussain — Wed, 10 Sep 2014 05:27:46 GMT

Gysbert,

fieldA has a lot of records matching in the date fields. As soon as I press the search button the fieldA selection clears and then all the records within the specified dates show up in the table.

I do not know why the selection clears up when fieldA records are within the Dates.

Thanks.

Re: Search is getting Cleared

Gysbert_Wassenaar — Wed, 10 Sep 2014 07:51:56 GMT

Can you post an example document that demonstrates the problem?

Re: Search is getting Cleared

sjhussain — Wed, 10 Sep 2014 08:01:29 GMT

Gysbert

We are working onsite with confidential data.

I have to strip down a lot which will take a lot of time.

Can you suggest something which might be feasible.

Thanks again

Sent from Samsung Mobile

Re: Search is getting Cleared

Gysbert_Wassenaar — Wed, 10 Sep 2014 08:07:14 GMT

Read this document: http://community.qlik.com/docs/DOC-1290

Re: Re: Search is getting Cleared

sjhussain — Thu, 11 Sep 2014 06:48:01 GMT

Gysbert,

Excellent Article about reducing and scrambling the data. I have done it on the file and am attaching it with this reply.

The problem i am having is as follows:

Mobile No. Selection disappears on date search

1. Select Mobile Number

2. Click on Call Button and you will be taken to the Call Screen

3. Filter the Dates and you will see that the selected mobile number disappears and all the records during the selected dates are shown.

Record not found selection shows all the records

-- Another problem I am having is that when the search results in not found then all the records are displayed

1. Select Mobile No. from Search Field

2. Enter number 123 in Search Text

3. Press Search button

4. All the records are shown rather than remaining emtpy

Thanks for all your support.

Re: Search is getting Cleared

Gysbert_Wassenaar — Fri, 12 Sep 2014 16:35:48 GMT

Mobile No. Selection disappears on date search

1. Select Mobile Number

2. Click on Call Button and you will be taken to the Call Screen

3. Filter the Dates and you will see that the selected mobile number disappears and all the records during the selected dates are shown

I can't reproduce step 3. After choosing a mobile number, further filtering on the dates does not clear the selection of the mobile number here.

Record not found selection shows all the records

-- Another problem I am having is that when the search results in not found then all the records are displayed

1. Select Mobile No. from Search Field

2. Enter number 123 in Search Text

3. Press Search button

4. All the records are shown rather than remaining emtpy

It's not possible to create an empty result set by making selections in Qlikview. If the search returns no result then no selection can be made (in green) and all values are shown as possible values (in white).