Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox calculated dimension

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

7 Replies
tresesco
MVP
MVP

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)

ngulliver
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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.

Not applicable
Author

I done it, thank you a lot Neil

ngulliver
Partner - Specialist III
Partner - Specialist III

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.

2013-08-13_1201.png

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

Regards,

Neil

Not applicable
Author

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?

ngulliver
Partner - Specialist III
Partner - Specialist III

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