Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kirsten_dc
Partner
Partner

Set Analysis with date range only works when selecting a dimension

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:

kirsten_dc_0-1611053590027.png

Without selecting the dimension

 

kirsten_dc_1-1611053638851.png

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!

3 Replies
Qlik1_User1
Creator III
Creator III

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

kirsten_dc
Partner
Partner
Author

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

Qlik1_User1
Creator III
Creator III

@kirsten_dc , try this

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