Problem comparing information over date ranges using set analysis

Anonymous — Thu, 12 Oct 2017 15:38:05 GMT

Hello all,

I'm having a lot of trouble trying to get set analysis to work for me. I've attached a test version of what I'm trying to achieve with a small amount of data.

The data is coming from sql and [Date] field is dd/MM/yyyy.

I've tested that my variables work correctly (three text boxes at the bottom) but still can't get the set analysis in CH05 to correctly work.

Essentially I want to get to a stage where I'm doing a sum of revenue for vMaxDate minus sum of revenue for vPrevWeek so I can dynamically see by a variety of dimensions the difference for either the current max date or the select date.

Hopefully that is enough information but please let me know if you need anything else.

Thanks

Tom

Re: Problem comparing information over date ranges using set analysis

sunny_talwar — Thu, 12 Oct 2017 19:45:38 GMT

Try this

=num(sum({$<Date = {"$(=$(vMaxDate))"} >} Revenue), '£#,##0')

Re: Problem comparing information over date ranges using set analysis

Anonymous — Thu, 12 Oct 2017 20:10:29 GMT

Sunny - I don't understand why it works, but it works, thank you very much.

Tom

topic Re: Problem comparing information over date ranges using set analysis in QlikView

Problem comparing information over date ranges using set analysis

Re: Problem comparing information over date ranges using set analysis

Re: Problem comparing information over date ranges using set analysis