Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

count max if

Hi Guys,

I have here a scenario which I only wanted to count the ID conversation with the last segment start time and with segment type as 'wrapup'.

Wrapup.PNG

since there is multiple id session for every id conversation. This is the desired result.

wrapupdesiredresult.PNG

Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: count max if

In a table with ID:Conversation and IDSmiley Frustratedession as dimensions, you could use this for the required result:

If(FirstSortedValue({<[Segment Type] = {'wrapup'}>} [IDSmiley Frustratedession], -[Segment Start Time]) = [IDSmiley Frustratedession], 1, 0)


1 Reply
MVP
MVP

Re: count max if

In a table with ID:Conversation and IDSmiley Frustratedession as dimensions, you could use this for the required result:

If(FirstSortedValue({<[Segment Type] = {'wrapup'}>} [IDSmiley Frustratedession], -[Segment Start Time]) = [IDSmiley Frustratedession], 1, 0)


Community Browser