topic Re: Filter Display in QlikView

Filter Display

Anonymous — Wed, 13 May 2015 12:07:10 GMT

I want to display filter Like This

Please help me

Thanks In advance

Best Regards

Anusha

Re: Filter Display

maxgro — Wed, 13 May 2015 12:11:46 GMT

maybe the multibox?

Re: Filter Display

Anonymous — Wed, 13 May 2015 12:25:18 GMT

Yes multibox only but how to avoid table name in above example,i Need to show only single dropdown box

Re: Filter Display

buzzy996 — Wed, 13 May 2015 12:33:32 GMT

try this,

Re: Filter Display

mohammadkhatimi — Wed, 13 May 2015 12:34:30 GMT

Hie...

Building a nicer, dynamic QlikView multibox The Qlik Fix!

Refer the link

Re: Filter Display

buzzy996 — Wed, 13 May 2015 16:06:39 GMT

tis option not helped u? let me know i can look at some thing if not.

Re: Filter Display

petter — Wed, 13 May 2015 20:06:44 GMT

You can actually achieve it with the help of a properly configured input box like this:

1. Create an Input Box

2. On the General Tab press New Variable

3. Name it for instance vMonth

4. Remove the Label that it automatically creates

5. On the Presentation Tab: Untick the Show Equal Sign

6. On the Constraints Tab select: Predefined Values Only

7. Select under Value List: Predefined Values in Drop-down

8. Tick the check-box Listed Values

9. In the expression underneath Listed Values write the following expression:

=Concat( {1} DISTINCT Month , ';' , Month )

10. On the Caption Tab untick the check-box Show Caption

11. Press OK

12. Size it properly by moving the spacer between the variable and "empty" label to the left

13. Go to Settings / Document Properties and the Triggers Tab

14. Under Variable Event Triggers select vMonth and click on the button Edit Action(s)

15. Click Add in the Actions dialog box that pops up

16. Select under Action Type: Selection

17. Select for Action: Select in Field

18. In the Field expression write: Month (or your Field name)

19. In the Search String exprssion write: =vMonth

20. Press OK and then OK.

I have attach a tiny QlikView app with the example...

Re: Filter Display

Anonymous — Thu, 14 May 2015 09:35:56 GMT

Hi Petter,

I am unable to display year values in dropdwon view ll u please expalin.I followed your instructions but still not able to do.

Please help me .I am attached my working document

Re: Filter Display

mohammadkhatimi — Thu, 14 May 2015 09:46:06 GMT

Hey try my link above...

And check attachment also

Hope helps you...

Re: Filter Display

petter — Thu, 14 May 2015 09:53:35 GMT

You just forgot to put in parameter two - the semicolon separator that the Concat() function needs to separate your years into distinct values...

You had:

=Concat({1} DISTINCT Year, Year)

It should be:

=Concat({1} DISTINCT Year , ';' , Year)

Re: Filter Display

Anonymous — Thu, 14 May 2015 09:55:02 GMT

Hi Mohammed,

What are the changes you have done in this

PLease explain clearly.

Re: Filter Display

Anonymous — Thu, 14 May 2015 10:01:45 GMT

I used this (=Concat({1} DISTINCT Year , ';' , Year)) expression only

but in inputbox it displays like 2011;2012;2013;2014

Re: Filter Display

petter — Thu, 14 May 2015 10:06:11 GMT

In your Listed Values in the Constraints tab of your Input Box properties dialog box you should have this:

=Concat({1} DISTINCT Year , ';' , Year)

Maybe you put the expression into the variable itself - you should not do that.

Re: Filter Display

Anonymous — Thu, 14 May 2015 10:09:03 GMT

Re: Filter Display

mohammadkhatimi — Thu, 14 May 2015 10:10:35 GMT

Did u checkd the attachment???

Is your requirement fulfilled??

Regards,

Mohammad

Re: Filter Display

petter — Thu, 14 May 2015 10:11:12 GMT

Remove the expression you put in under "Settings for Selected Variable".

The Listed Values and the expression: =Concat(........ is enough

Re: Filter Display

mohammadkhatimi — Thu, 14 May 2015 10:13:00 GMT

In Values, you just write one value...like in my qvw I have kept 2015 value as default.

Regards,

Mohammad

Re: Filter Display

Anonymous — Thu, 14 May 2015 10:18:06 GMT

I am not write any expression in "settings for selected variable".It aumatically shows those vales after writing the expression in listedvalues.

Re: Filter Display

mohammadkhatimi — Thu, 14 May 2015 10:21:01 GMT

Dont write expression in your variable just keep it blank...

Re: Filter Display

Anonymous — Thu, 14 May 2015 10:22:31 GMT

Yes mohammed i checked its fyn but when i am trying in my qvw its not working fine.it Displays like

2011;2012;2013