topic Re: Expression if statement in QlikView

Expression if statement

Anonymous — Tue, 11 Aug 2015 13:50:21 GMT

Hello,

Can anybody help or advize me with the next expression?

I need the result from column X of WeekEinde 28-6-2015 to show in the dashboard as month Juny

I do not want to change the calendar, because not all the data is a count like that, mostly it is a sum of the data from the weeks belong Juny..

if(Max(WeekEinde) < JaarMaand, sum(X))

Thanks already!

lironbaram — Tue, 11 Aug 2015 13:56:38 GMT

something isn't clear enough for me in your expression

you compare to fields that contains different set of data

you can try

=FirstSortedValue(aggr(sum(X),WeekEinde),aggr(-WeekEinde,WeekEinde))

Anonymous — Wed, 12 Aug 2015 13:39:02 GMT

Hello Liron,

Your answer works fine!

Thanx very much for the hint.

Greets, Nelly

lironbaram — Wed, 12 Aug 2015 13:56:48 GMT

hi good to hear

so please mark the answer as correct so future users could benefit from it also