topic Exclud data from a text box in QlikView

Exclud data from a text box

Thu, 09 Feb 2012 21:12:55 GMT

Hi Guys,

I am running the following report which is pulling data per month and then date.

how can I make the report shows only the dates related to that month in the Day text Box?

Thxs

pover — Thu, 09 Feb 2012 22:13:50 GMT

Enable the "Hide excluded values" option in the General tab of the properties window.

Karl

Thu, 09 Feb 2012 22:21:10 GMT

I tried that one but It won't help..

It will exclud them but will keep huge gray space before or after the data depending on the Month.

Like If I click on JUL from the month box, then I see gray space on the day box andf i have to scroll down to view the data

pover — Thu, 09 Feb 2012 22:23:29 GMT

Ok. In the sort tab, enable the "By State" option and change it to "Ascending".

Karl

Thu, 09 Feb 2012 22:26:19 GMT

It didn't help as well..:(

pover — Thu, 09 Feb 2012 22:30:29 GMT

That didn't move the possible white values to the beginning and push the excluded gray area below?

Thu, 09 Feb 2012 22:34:10 GMT

Nope!

pover — Thu, 09 Feb 2012 22:37:21 GMT

How do you see the selection in the attached file?

Thu, 09 Feb 2012 22:45:42 GMT

Yours is working just fine but it is not working on my report even I have the same setting!

CELAMBARASAN — Fri, 10 Feb 2012 05:41:52 GMT

Hi,

Try with the below expression

=ValueList($(=chr(39)&Concat(DISTINCT DayFieldName,chr(39)&',' &chr(39))&chr(39)))

It will work as your need

Celambarasan

CELAMBARASAN — Fri, 10 Feb 2012 09:58:51 GMT

Hi,

Use this expression in listbox because in the previous you cann't able to select.

=Aggr(Date,Date)

Hope it helps

Celambarasan