topic Re: Listbox calculated dimension in QlikView

Listbox calculated dimension

Tue, 13 Aug 2013 08:58:28 GMT

Dear all,

We want to have simple list box, where the names of the departments are visible, but only those which haven't sent their reports to the management. We havent got in the data model such a column, which has been already counted. So we must somehow write it in the expression, but the names ... can't be sum or.. something like this

how can we do it?

give me some idea

Re: Listbox calculated dimension

tresB — Tue, 13 Aug 2013 09:17:14 GMT

There has to be some logic how you decide that the department has sent report to management or not, based on that you can populate your listbox. list box expression might look like:

If( <condition>, Department) , or

if( ReportSentFlag='Y', Department)

Re: Listbox calculated dimension

ngulliver — Tue, 13 Aug 2013 09:20:21 GMT

If I understand you correctly, instead of using a List box you can try to use a Chart Object\Straight Table.

This gives you the ability to use set analysis in your expression to narrow the range of data being returned. You can then hide all the expression column in the Presentation tab leaving you with the one column listing the department names.

Regards,

Neil

Re: Listbox calculated dimension

Tue, 13 Aug 2013 10:24:38 GMT

it sounds great, just could you tell me how to hide the second column. I done the strait table already.

Thank you Neil

Answer to : tres qv

- it doest work Tres, i try your proposal, but it doesn't work.

Re: Listbox calculated dimension

Tue, 13 Aug 2013 11:02:55 GMT

I done it, thank you a lot Neil

Re: Listbox calculated dimension

ngulliver — Tue, 13 Aug 2013 11:04:47 GMT

Hi,

You can hide the columns in the Presentation tab. In the top left corner you have a list of the columns. Below this are the options to show or hide a column.

Click on each field a choose whether to hide or show them.

Regards,

Neil

Re: Listbox calculated dimension

Tue, 13 Aug 2013 12:30:56 GMT

and last question Neil, thank you a lot for the previous.

I want to show me only the reports for the last month year, which was choosen from my calendar, so i wrote this expression : count({<MonthYear = {$(=max(MonthYear))}, Key = {2}>}Key)

but it doesn't work .... Is my logic right?

Re: Listbox calculated dimension

ngulliver — Wed, 14 Aug 2013 08:08:50 GMT

I'm not sure without understanding your data better. You're missing the ' around the selection.

I would probably use sum({<MonthYear={'$(=addmonths(max(MonthYear), -1)'}>}Key)

Regards,

Neil