Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

juraj_pavol
New Contributor

Count within Date interval

Hi all,

I try to solve following problem but with no success.

I have data in following structure

Item nameActivation dateExpiration date
Blue01/201803/2018
Gree01/201805/2018
Red02/201805/2018
Pink03/201806/2018
Black04/201806/2018

On the sheet I have Data picker where I can select date in format eg. 04/2018 = Select month

1. I need count all records where Activation date <=Select month <= Expiration date

I try this but it not works:

Count(distinct{$<[Select month]={">=[Activation date]<=[Expiration date]"}>}[Item name])

2. I need count all records where Activation date <=Select month <= Expiration date

and also if Expiration date is NULL it will be counted to total count


Please could you help me.

Thanks in advance. 

Community Browser