topic Re: num sum with mathematical signs in QlikView

num sum with mathematical signs

Wed, 30 Jul 2014 10:11:22 GMT

Hello,

I am working on the following formula

=num(sum({<SalesChannel={'Internet'},Type_Forfait={'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39))

it is regarding hotel reservations. in the following formula, i am counting only Reservation from INTERNET and with the Type_forfait = Forfait, offres spé...

what if now i would to count the hotel reservations which NOT including Type_forfait = Forfait, offres spé.

i was just thinking of using <> instead of = after Type_forfait...but it is not working..

thanks for your help.

Re: num sum with mathematical signs

c_gilbert — Wed, 30 Jul 2014 10:18:42 GMT

I think you would just put a minus symbol before the equals sign after Type_Forfait.

Re: num sum with mathematical signs

Wed, 30 Jul 2014 10:23:12 GMT

=num(sum({<SalesChannel={'Internet'},Type_Forfait=-{'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39))

Re: num sum with mathematical signs

Wed, 30 Jul 2014 12:13:04 GMT

thanks for your comments...i did not find this solution do you know why we can not use <> different ??

Re: num sum with mathematical signs

Wed, 30 Jul 2014 12:20:32 GMT

=num(sum({<SalesChannel={'Internet'},Type_Forfait-={'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39))

Should work.

I would also have a look this thread, as it explains about the different operators you can use

Set Analysis: syntaxes, examples

Hope that helps

Joe

Re: num sum with mathematical signs

Wed, 30 Jul 2014 12:31:05 GMT

thanks a lot great help