2 dimension in 1 listbox

[secolaux]

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.

[Anonymous · Accepted solution]

you mean something like this?

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]

Exactly what I was looking for.

Dont know this would be that easy tho

Thx, have a nice day.

[Anonymous]

great to know!