Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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!!
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')
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 :
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')
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 !!)