Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.