topic Re: set analysis without aggr, only,... in QlikView

set analysis without aggr, only,...

phongnnguyen — Sun, 08 Jul 2018 16:55:06 GMT

Hello guys,

How to make a set analysis without aggr, only...I just wanna show a list in my expression

firstworkdate( today() , 5 , ...{<tradedate = checkwd={'1'}>} tradedate)

I wanna show all holidays in list by this expression : {<tradedate = checkwd={'1'}>} tradedate

But i dont know what are things i should use

Please give me the solutions

Thanks with regards,

jonathandienst — Sun, 08 Jul 2018 18:03:14 GMT

The expression would look like this:

=FirstWorkDate(Today(), 5, $(=Concat({<tradedate = checkwd={'1'}>} chr(39) & tradedate & chr(39), ',')))

You might want to break that into parts by using a variable (the double = is not a typo, make sure they are separated by a space):

Set vHolidays = =Concat({<tradedate = checkwd={'1'}>} chr(39) & tradedate & chr(39), ',');

Then your expression is

=FirstWorkDate(Today(), 5, $(vHolidays))