topic Re: Custom List box in QlikView

Custom List box

Mon, 13 Jan 2014 07:05:46 GMT

Hi,

I have a question. Experts pls shed in your thoughts as i am pretty new to qlikview.

I would like to show 1 or 2 List boxes to the users with the custom values but then these values will be input for the SQL query to fetch the data. Kindly let me know how it can be done?

For example: The user will be presented a list box like this. Based on his selection, qlikview has to pass on the input criteria for the SQL.

If i select last 7 days, then i should pass identify the system date and subtract 7 days and pass on the date range to SQL query. Kindly help

Re: Custom List box

Nicole-Smith — Mon, 13 Jan 2014 16:23:23 GMT

You need to use variables with an input box instead of a list box. This is because we must use the variables in the load script in order to tell it what dates to load in.

The attached should give you what you need to get started.

Re: Custom List box

Mon, 13 Jan 2014 16:36:41 GMT

Hi, aru aru,

you can load all dates,

when with a variable with a value conditioned with your choice, use this variable in set analisys,

Re: Custom List box

Thu, 16 Jan 2014 13:08:13 GMT

thanks guys

Re: Custom List box

Nicole-Smith — Thu, 16 Jan 2014 13:59:07 GMT

Please mark helpful and correct answers in order to help others find solutions to their problems as well