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: 
secolaux
Contributor II
Contributor II

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
Anonymous
Not applicable

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

View solution in original post

3 Replies
Anonymous
Not applicable

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
Contributor II
Contributor II
Author

Exactly what I was looking for.

Dont know this would be that easy tho

Thx, have a nice day.

Anonymous
Not applicable

great to know!