Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Set analysis in script Qliksense

Hi,

I am trying to obtain the latest date ([Dateur JT -etjt]) according to some conditions on other varaibles ([Etape -etjt]=alfa,beta [Typ attribution-etjt] = gamma). Result should be grouped by the key of the dataset --> [No interne tpg -JT]. it means that I am looking for the latest date for each value of [No interne tpg -JT].

Table:

[No interne tpg -JT],

[Etape -etjt],

[Typ attribution-etjt],

[Dateur JT -etjt],

[Id attribution-etjt]

Anyone can help?

Thanks

Giovanna

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Set analysis in script Qliksense

Try this:

LOAD

[No interne tpg -JT],

max([Dateur JT -etjt])  as LatestDate

FROM Table

WHERE match([Etape -etjt].'alfa,'beta')

AND  [Typ attribution-etjt] = gamma)

GROUP BY [No interne tpg -JT];

3 Replies
mov
Esteemed Contributor III

Re: Set analysis in script Qliksense

Try this:

LOAD

[No interne tpg -JT],

max([Dateur JT -etjt])  as LatestDate

FROM Table

WHERE match([Etape -etjt].'alfa,'beta')

AND  [Typ attribution-etjt] = gamma)

GROUP BY [No interne tpg -JT];

Not applicable

Re: Set analysis in script Qliksense

yes it works! I have found another  solution very similar to this but this is more concise, thanks a lot!

md_qlikview
Contributor II

Re: Set analysis in script Qliksense

Hi,

Try following script -

Table1:

Load

[No interne tpg -JT],

Max([Dateur JT -etjt]) as MaxDate

From Tablename

Where
Wildmatch([Etape -etjt],'alfa','beta') and Wildmatch( [Typ attribution-etjt], 'gamma');

Community Browser