topic Re: 2 dimension in 1 listbox in App Development

2 dimension in 1 listbox

secolaux — Fri, 17 Mar 2017 15:15:14 GMT

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 — Mon, 20 Mar 2017 09:46:42 GMT

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 — Mon, 20 Mar 2017 10:08:13 GMT

Exactly what I was looking for.

Dont know this would be that easy tho

Thx, have a nice day.

Anonymous — Tue, 21 Mar 2017 01:09:33 GMT

great to know!