topic Re: sort and field question in QlikView

sort and field question

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys:

My first question is pretty basic:

1) i have a field [Week No] and i want to only show Week 1, 2, 3, 4, 5, 6. How would i do that. I tried Week no = {1, 2, 3, 4, 5, 6} but i know this is wrong.

my second question is a bit complicated (sorting):

I made this calculated dimension. I want it to display as WK14, WK15, WK16 etc.

Week formula is:

=pick(match(-1,

YEAR = '2017' and DAY >= 2415 and DAY <= 2421 ,

YEAR = '2017' and DAY >= 3183 and DAY <= 3189 ,...

'WK1', 'WK2, 'WK3')

Day formula is:

=pick(match(-1,

GLYEAR = '2017' and DAYNO = 2415 ,

GLYEAR = '2017' and DAYNO = 2416 , ....

'Sun', 'Mon', Tue'...)

Thanks,

Re: sort and field question

el_aprendiz111 — Tue, 08 Nov 2016 16:39:09 GMT

Hi,

1- Use a master calendar

2- you have a sample of data in Excel

Re: sort and field question

Anil_Babu_Samineni — Tue, 08 Nov 2016 16:47:28 GMT

For first one like this

If(match([Week no] , '1', '2', '3', '4', '5', '6'))

Second one still trouble shooting

Re: sort and field question

jadams123 — Wed, 16 Nov 2016 12:54:30 GMT

i solved it...took me i think 2 weeks...but its this:

dual('WK' & num(14), num(14)),
dual('WK' & num(15), num(15)),
dual('WK' & num(16), num (16)),
dual('WK' & num(17),num(17)),

Now i have to learn how to do (sun, mon, tue....) errrr