topic Search Box in QlikView

Search Box

bharatkishore — Tue, 11 Apr 2017 07:04:37 GMT

Hi All,

I have written the following code:

Tag Field Dimension With '$hidden';

Tag Field Month With '$hidden';

Dimensions:

LOAD

INLINE [

Dimension

Month];

Now the issue what i am facing is i need to able to select Month field in search object. But i am not able to view that field in SEARCH OBJECT box. Can you please help how to get that field in search object.

Attached the qvw for more reference.

Thanks,

Bharat

Re: Search Box

Anil_Babu_Samineni — Tue, 11 Apr 2017 07:08:21 GMT

I am not following you, You want to show Selection box it self. Which one you want to show. Like below

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:10:52 GMT

Hi Anil,

In search object i need to add that field called Fiscal_Month_12NC. Because in search object properties when ever i try to add Fiscal_Month_12NC field i am not able to see that one.

Kindly let me know if you require anything more..

Re: Search Box

tresB — Tue, 11 Apr 2017 07:12:05 GMT

Right click on search object->General->List of Fields->Click on the expression button (...)->'Show System Fiels' enable it. Now you would be able to see and select your hidden fields from the field list.

Or, you can even type in your field name in the expression window.

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:15:44 GMT

Hi Tresesco,

I have enabled it but still i am not able to see that field...

Re: Search Box

Anil_Babu_Samineni — Tue, 11 Apr 2017 07:18:28 GMT

This you meant to say this? In fact, Your inline is showing only Field that's called Dimension. So, Fiscal... is the value which comes under Dimension it self.

Re: Search Box

tresB — Tue, 11 Apr 2017 07:18:55 GMT

Your app has only one field called 'Dimension' and no field called 'Fiscal_Month_12NC'. In fact, 'Fiscal_Month_12NC' is a field value of Dimension field.

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:20:41 GMT

Yes Anil i need to able to select Fiscal_Month_12NC... Not Dimension... Only field called Fiscal_Month_12NC.

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:22:16 GMT

Please check the attached app...

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:23:11 GMT

Yes, is there any way that i can able to select only Fiscal_Month_12NC in search object...

Re: Search Box

tresB — Tue, 11 Apr 2017 07:30:49 GMT

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 07:33:40 GMT

Yes, I need to see the fields like this in search object and need to add that field value called Fiscal_Month_12NC.

Re: Search Box

tresB — Tue, 11 Apr 2017 07:43:45 GMT

Sorry, this explanation is not helping. Could you explain your business need rather?

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 08:06:25 GMT

Sorry if my explanation is wrong.. I will tell you my scenario.

Firstly i am having a Table Name called Dimensions.

In that table i am having a Field Name called Dimesion.

In that field i have field values called 'Fiscal_Month_12NC and 'Year1'.

Now my requirement is i need to display dimension in list box like below shown:

The reason why i have created this dimension (list box)is when ever i click the necessary field value based on the selection the field values should add in the chart. I have given some conditional statements.

And the field called 'Fiscal_Month_12NC' has data in it. So now i need to create a Search box where the user can type and he can see the data in it. For example please see the below image:

Now my problem i am not able to see that Fiscal_Month_12NC to select that field in search object . I need to able to view that field and that field in Search object... Hope this explains you better.

Please find the attached app. Fiscal_Month_12NC has data and i need to able to add that Fiscal_Month_12NC in search object.

NOTE: FISCAL MONTH IMAGE IS JUST AN EXAMPLE

Re: Search Box

tresB — Tue, 11 Apr 2017 08:32:32 GMT

I have added that field in the search object following the steps explained above.

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 09:08:15 GMT

Thanks a lot.. But if i have two more fields.. Is it possible those as well..

Re: Search Box

bharatkishore — Tue, 11 Apr 2017 09:09:53 GMT

I got it.. Thanks a lot for your time. Thank you so much...