Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ariel_klien
Valued Contributor

Nested Table -count only First Value

Hello all,

I need help with the following:

i have a table like this:

Object_TypeObject_IDDATE
AAA101/01/13
AAA201/01/13
AAA302/01/13
AAA205/01/13
AAA105/01/13
BBB101/01/13
BBB201/01/13
BBB301/01/13
BBB401/01/13
BBB402/01/13

I need to count only the first Object_Type & Object_ID .

Discard the raw's in bolt.

If I will use count(Object_Id) in expression and Object_Type and Date in Dimensions I will get:

Object_TypeDATECount(Object_ID)
AAA01/01/132
AAA02/01/131
AAA05/01/132
BBB01/01/134
BBB02/01/131

I need that the table will be like:

Object_TypeDATECount
AAA01/01/132
AAA02/01/131
BBB01/01/134

How can I achieve that?

BR

Ariel

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Nested Table -count only First Value

See attached qvw


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Nested Table -count only First Value

See attached qvw


talk is cheap, supply exceeds demand
ariel_klien
Valued Contributor

Re: Nested Table -count only First Value

Hi Gysbert.

As usually working fine!!

Thanks a lot.

Ariel