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: 
jjvigneC
Contributor
Contributor

calculated field

Hello

I have this table

LOAD * INLINE [
Date, Code, Number
01.01.2019, TRUE, 7
01.01.2019, FAULT1, 3
01.01.2019, FAULT2, 1

01.02.2019, TRUE, 7

01.03.2019, TRUE, 7
01.03.2019, FAULT1, 2
];

I would like a view giving

date;% fault1;% fault2

01.01.2019;3/7;1/7

01.02.2019;

01.03.2019;2/7;

 

any idea ?

1 Reply
arpitkharkia
Creator III
Creator III

Create a straight table with Date as dimension and use the following expresions

MaxString({<Code={'FAULT1'}>}Number)
/
MaxString({<Code={'TRUE'}>}Number)

 

MaxString({<Code={'FAULT2'}>}Number)
/
MaxString({<Code={'TRUE'}>}Number)