Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aminehaddar
Contributor II
Contributor II

group by and vertical expression

Hello,

I have :

Load

Code, code_ass, customer, duration, capital... 

from ..TD.xlsx

I have this table:

 

Codecode_assCustomerDuration
0001123AmineX3
0001124AmineH3
0002125x13
0002126x14

0003

127x25
0004128x32

I need to group by Code and calculate the number of code_ass ( NBR).


Then,

the goal is to indicate when Number of code_ass=2 and duration is equal for the both code_ass grouped by Code , '1' else '0'.


Exemple:

code=0001

NBR = 2

x= Duration of code_ass = 123 : 3

y= Duration of code_ass = 124 : 3

if x = y and NBR = 2 then '1' else '0'


Any help please?

Regards

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

3 Replies
shiveshsingh
Master
Master

May be this?

aminehaddar
Contributor II
Contributor II
Author

Thanks a lot bro

shiveshsingh
Master
Master

Glad to know it worked