Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit777
Specialist
Specialist

expression

Hi

I have below sample data. I want count entity with date greater than today and show country wise.

   

countryentitydate
count1a3/18/2016
count2b7/18/2016
count1c5/18/2016
count1d9/18/2016
count2e5/18/2016
count2f2/18/2016
count1g5/18/2016
count1h1/18/2016
count2i8/18/2016

Output

count1  3

count2  2

1 Solution

Accepted Solutions
sunny_talwar

You can either do this using a flag created in the script:

Table:

LOAD country,

     entity,

     date,

     If(date >= Today(), 1, 0) as Flag

FROM

[https://community.qlik.com/thread/217313]

(html, codepage is 1252, embedded labels, table is @1);

Expression:

=Count({<Flag = {1}>}entity)

or you can try this expression

=Count({<date = {"$(='>=' & Date(Today()))"}>}entity)

View solution in original post

5 Replies
Not applicable

Hi ,

try like below in expression,

=aggr(count({<date={">$(=date(today(),'MM/dd/yyyy'))"}>}entity),country)

sunny_talwar

You can either do this using a flag created in the script:

Table:

LOAD country,

     entity,

     date,

     If(date >= Today(), 1, 0) as Flag

FROM

[https://community.qlik.com/thread/217313]

(html, codepage is 1252, embedded labels, table is @1);

Expression:

=Count({<Flag = {1}>}entity)

or you can try this expression

=Count({<date = {"$(='>=' & Date(Today()))"}>}entity)

Anonymous
Not applicable

use a straight table with Dimension country

and Expression: if (date> today(), Count(Country))

if you need to prepare in script:

NewTable:

load Country,

Count(Country) as counter

resident table

where date > today()

Group by country

Kushal_Chawda

Create Straight Table

Dimension:

Country

Expression:

=Count({<entity ={"=Date>today()"}>}entity )

sunny_talwar

How are you getting a count of 2 for count2?