topic Set Analysis and If in QlikView

Set Analysis and If

alec1982 — Wed, 31 Jul 2013 07:02:47 GMT

Hi Guys,

I am trying to build an expression inside a text box as follow:

=if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),Count({$<[DateType]={"RFS"} >}[Name]))

For some reason it is not working..

I have tried to put only Count({$<[DateType]={"RFS"} >}[Name])) and got the nrs,

and I have tried to put if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),0,1) and it works..

But whenever I put them together I dont get the right nr..in fact I get "-"

Thxs,

Badr

sivarajs — Wed, 31 Jul 2013 07:19:49 GMT

Count({$<[DateType]={"RFS"} >} if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),[Name]))

Check your DateLL date format is matching with today() format

alec1982 — Wed, 31 Jul 2013 14:22:52 GMT

Thxs so much for all your help!