if function in a countd

[Anonymous]

Hi all,

Im pretty new in qlikview and I wonder if you could help me?

I have some IDs and different date for each field. This is the case:

ID

ID	Type of account
a	1
a	2
a	7
a	8
b	1
b	2
c	7
d	1
d	7

So I want a table with the following rules:

Per each ID:

• count distinct of Types of account - this I know how to create the field
• If any of the ID has the Type of account 7.

Conclusion I would like to have:

ID	Countd (types of account)	Does it have Type of account ·7?
a	4	Yes
b	2	no
c	1	Yes
d	2	Yes

I look forward for your help Thanks!!

[sunny_talwar]

May be a straight table with

Dimension

ID

Expressions

Count(DISTINCT [Type of account])

If(Count(DISTINCT {<[Type of account] = {7}>} [Type of account]) > 0, 'Yes', 'No')

[susovan]

You can also try this,

1. =Count(ID)

2. =if((Aggr(if([Type of Account]='7','7','0'),ID,[Type of Account]))='0','No','Yes')

Output :

[pathiqvd]

Hi,

     Check This,

Test:

LOAD * INLINE [

    ID, Dat

    a, 1

    a, 2

    a, 7

    a, 8

    b, 1

    b, 2

    c, 7

    d, 1

    d, 7

];

Dim:- Id

exp:-

1)count(Dat)

2)if(count({<Dat={'7'}>}Dat)>0,'Yes','No')

[Anonymous]

Awesome ! I worked out

Do you have extra information about this toppic? I would like to learn more.

Muchas gracias a todos!! (thanks a lot to everyone !!)