Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

m_tapper
New Contributor III

Set analysis (works in QlikView, not in Sense...)

Hi all,

I have a problem with set analysis...

I have a set analysis that works in QlikView but not in Qlik Sense (see below). I know it would be a lot better to work with variables but our customer use an older version of Sense that does not handle dynamic variables.

Have any of you experienced anything similar or have any suggestion to me??

The set analysis:

Sum( {$< Datum={">=$(=if(Max(Datum)>Date(Today()), WeekStart(Today()-35), WeekStart(Max(Datum)-35)) )<=$(=if(Max(Datum)>Date(Today()), WeekEnd(Today()-7), WeekEnd(Max(Datum)-7)))"} >} Belopp)

 

Thank you, thank you, thank you!!!!!!!!!!!!!!!!!!!!!!!!!

Regards

Michelle

2 Replies
MVP
MVP

Re: Set analysis (works in QlikView, not in Sense...)

Have you double checked the date formats returned from the dollar sign expansions, compared to the Datum field format?

Dates in Set Analysis

And could you be a bit more detailed what you mean with 'not working'?

m_tapper
New Contributor III

Re: Set analysis (works in QlikView, not in Sense...)

Hi and thanks for the tip!

It took me the right way. The format was correct but I had to switch from English to Swedish collation to get it right. Took some time to get it right but in the end it worked out!!

You saved my weekend

Regards

Michelle

Community Browser