topic Re: Set Analysis with date range only works when selecting a dimension in QlikView

Set Analysis with date range only works when selecting a dimension

kirsten_dc — Tue, 19 Jan 2021 10:59:26 GMT

Hi all,

I'm having issues with creating an expression with set analysis working with a date range. The start date is depending on the dimension. My problem is that I have to select a dimension (here: Article) to show the correct result of the expression.

But that is not what I want. The result should always be represented.

Here you can see an example:

Without selecting the dimension

With selecting the dimension

I used this expression:

sum( {$<gDateName={">=$(=ActualStockDate)"}>}ArticleTicketQuantity)

I have attached my qvw file. Please tell me what I'm missing.

Thanks in advance!

Re: Set Analysis with date range only works when selecting a dimension

Qlik1_User1 — Tue, 19 Jan 2021 11:32:14 GMT

@kirsten_dc Try this
sum(Total {$<gDateName={">=$(=ActualStockDate)"}>}ArticleTicketQuantity)

Re: Set Analysis with date range only works when selecting a dimension

kirsten_dc — Tue, 19 Jan 2021 11:52:22 GMT

I already tried using "Total". It doesn't work...

Re: Set Analysis with date range only works when selecting a dimension

Qlik1_User1 — Tue, 19 Jan 2021 12:28:07 GMT

@kirsten_dc , try this

sum(Total {$<gDateName={">=$(=MIN(ActualStockDate))"}>}ArticleTicketQuantity)
Instead of MIN you can use another aggregator function based on the requirement.