topic Re: Please Help....Set Analysis for "Yesterday" in QlikView

Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 09:32:57 GMT

Hi,

I am new to Qlikview and am trying to restrict the results of an expression using a Variable $(vSales Gross) to only show values from the previous day.

I have tried =({<[Date]={'$(=Date(today()-1))'}>} $(vSales Gross))

Any help would be greatly appreciated

Re: Please Help....Set Analysis for "Yesterday"

Gysbert_Wassenaar — Wed, 11 Mar 2015 11:39:38 GMT

Try =sum({<[Date]={'$(=Date(today()-1))'}>} $(vSales Gross))

Re: Please Help....Set Analysis for "Yesterday"

Anonymous — Wed, 11 Mar 2015 11:47:48 GMT

We have no idea what's inside that $(vSales Gross)

It could be another sum() there. In this case the set must be inside this variable.

Re: Please Help....Set Analysis for "Yesterday"

Gysbert_Wassenaar — Wed, 11 Mar 2015 11:50:42 GMT

True, we also have no idea if the Date field contains date values or text values or any values at all.

Re: Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 12:26:56 GMT

Hi Tim,

Try below expression.

sum({<Date={'$(=Date(today()-1))'}>} $(vSales Gross))

Thanks,

krish

Re: Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 12:31:59 GMT

try

Only({<[Date]={'$(=Date(today()-1))'}>} $(vSales Gross))

Re: Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 13:09:10 GMT

Hi,

Thanks. The Date field is date values and the Variable does contain Sum().

Tim

Re: Please Help....Set Analysis for "Yesterday"

Anonymous — Wed, 11 Mar 2015 13:13:52 GMT

That means that the set should be inside the variable. But you apparently use it somewhere else so can't change it. In this case don't use it for the "yesterday" calculation. Use expression per Gysbert but instead of the variable use field to sum.

If it is more complex than that, tell us what is the variable definition.

Re: Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 13:21:28 GMT

Thanks,

The Variable definition is sum([AGG Sales])+sum([IB Sales])+sum([OB Sales])+sum([WEB Sales])

Tim

Re: Please Help....Set Analysis for "Yesterday"

Anonymous — Wed, 11 Mar 2015 13:24:58 GMT

So, your "yesterday" expression is:

sum({<[Date]={'$(=Date(today()-1))'}>} [AGG Sales])

+sum({<[Date]={'$(=Date(today()-1))'}>}[IB Sales])

+sum({<[Date]={'$(=Date(today()-1))'}>}[OB Sales])

+sum({<[Date]={'$(=Date(today()-1))'}>}[WEB Sales])

Re: Please Help....Set Analysis for "Yesterday"

Wed, 11 Mar 2015 13:32:04 GMT

Sorted.

Many Thanks for your help!

Tim