Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
secolaux
New Contributor

2 dimension in 1 listbox

Hello,

I'm kinda new in QlikSense (server) and can't achieve what the user would like to have access to.

Here is the problem : I got some data wich could be resume like this :

DATA_VALUE     DATA_TYPE    MONTH     YEAR

10                         type1              1                   2015

9                           type2              1                   2015

10                         type1              2                   2015

                                        .....

12                         type3              2                   2017

My goal : the user select differents combinaisons of (Month + Year), which will be shwon in a histogramm.

I already use the extension bi-era.com_listbox but cant display all the combinaisons of Year + Month (1/2015, 2/2015, ...., 3/2017)

Ideas ?

Thanks a lot,

SC.

1 Solution

Accepted Solutions
yddona_lyn
New Contributor III

Re: 2 dimension in 1 listbox

you mean something like this?

img.PNG

1. you can drag your MONTH field in the sheet

2. in thefield, concatenate the MONTH & YEAR and it will show up as combined

3 Replies
yddona_lyn
New Contributor III

Re: 2 dimension in 1 listbox

you mean something like this?

img.PNG

1. you can drag your MONTH field in the sheet

2. in thefield, concatenate the MONTH & YEAR and it will show up as combined

secolaux
New Contributor

Re: 2 dimension in 1 listbox

Exactly what I was looking for.

Dont know this would be that easy tho

Thx, have a nice day.

yddona_lyn
New Contributor III

Re: 2 dimension in 1 listbox

great to know!