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

Input Box Sort Order with unique Values

Hi,

I have a Problem with an Input Box.

I created one for Year and one for Period. Now I Need one for month.

So far so good. Now the Problem. I want to have the month from January to December (but only once in the list)

In the Variables-Section I put in listed values the following Expression.

=Concat( {1} DISTINCT coda_month, ';' , coda_period)

With this Expression I get January twice (Period 0 and 1 are Jan) and December three times (Periods 12 to 14 are Dec).

 

Does someone has an idea of solving this?

Thanks in advance

Chris

1 Solution

Accepted Solutions
sunny_talwar

or this

=Concat(DISTINCT {1<coda_period = {'*'} - {0, 13, 14}>} coda_month, ';' , coda_period)

View solution in original post

3 Replies
sunny_talwar

How about if you do this:

=Concat(DISTINCT {1<coda_period -= {0, 13, 14}>} coda_month, ';' , coda_period)

sunny_talwar

or this

=Concat(DISTINCT {1<coda_period = {'*'} - {0, 13, 14}>} coda_month, ';' , coda_period)

Not applicable
Author

Hi Sunny,

very much thanks again. It works.