vendredi 4 septembre 2015

qlikview Adding another variable to a count expression

I want to add another part to this count expression to limit a user.

Something like and [User] <> 'MATT' adding into my code:

count({$<[P Description] ={"$(=concat([M Description],'","'))"},
[P C Description] ={"$(=concat([M C Description],'","'))"},
[A exempt] = {'Non-exempt'},[Late P] = {'Late P'}>}
aggr(if([P Created Month Date] >= ($(vToday)-[P Created Month Date]),
count([P Number])),[P Number]))

I have tried:

count({$<[P Description] ={"$(=concat([M Description],'","'))"},
[P C Description] ={"$(=concat([M C Description],'","'))"},
[A exempt] = {'Non-exempt'},[Late P] = {'Late P'}>}
aggr(if([P Created Month Date] >= ($(vToday)-[P Created Month Date]) and [User] <> 'MATT',
count([P Number])),[P Number]))

But this makes no difference.

Aucun commentaire:

Enregistrer un commentaire