Set Analysis with date range only works when selecting a dimension

[kirsten_dc]

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!

[Qlik1_User1]

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

[kirsten_dc]

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

[Qlik1_User1]

@kirsten_dc , try this

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