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

Help with expression inside multibox

Hi,

This might sound simple but am really not able to find a solution for this till now.

I need to have a multibox that will show year,quarter,month and week. In each drop down (for each of the mentioned items), i need only those values for which the count of survey_id is greater than one.

making it more clear, lets take the example of year. year is being taken from a calender table that has years ranging from 1800 to 2500.

I just need those years for which the corresponding count of survey_id is >0, to be shown in the drop down.

can anyone helpme frame the expression that will mean.. show only those years in 'year' drop down, for which the corresponding count(survey_id)>0

something like =if( (count{<Year>}(survey_id))>0, Year)

however the above expression returns no values.

plz help

thanks,

vishnu

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

you can use 

aggr(if(count(survey_id)>0,Year),Year)

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

you can use 

aggr(if(count(survey_id)>0,Year),Year)

sivarajs
Specialist II
Specialist II

Change the expression like

count({<Year>}(if(survey_id>0, Year)))

Not applicable
Author

Thanks a lot liron..

I havnt used the aggr function in qlikview previously..

I now know that this can come really helpful..

thank you once again