topic Re: expression in QlikView

expression

ankit777 — Wed, 25 Nov 2020 16:16:04 GMT

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

Output

count1 3

count2 2

Wed, 18 May 2016 09:18:56 GMT

Hi ,

try like below in expression,

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

sunny_talwar — Wed, 18 May 2016 09:20:21 GMT

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 — Wed, 18 May 2016 09:20:42 GMT

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 — Wed, 18 May 2016 09:21:33 GMT

Create Straight Table

Dimension:

Country

Expression:

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

sunny_talwar — Wed, 18 May 2016 09:23:30 GMT

How are you getting a count of 2 for count2?