topic Re: if function in a countd in QlikView

if function in a countd

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

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	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!!

Re: if function in a countd

sunny_talwar — Wed, 07 Dec 2016 20:53:37 GMT

May be a straight table with

Dimension

Expressions

Count(DISTINCT [Type of account])

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

Re: if function in a countd

susovan — Thu, 08 Dec 2016 06:16:58 GMT

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 :

Re: if function in a countd

pathiqvd — Thu, 08 Dec 2016 07:28:44 GMT

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')

Re: if function in a countd

Anonymous — Thu, 08 Dec 2016 15:05:48 GMT

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 !!)