Formula

[D_SARANYA5]

Hello All,

I'm new to Qlik sense... I would like to know what formula should we use to calculate the value of particular line items in a column.

Eg: ref below table... I would like to calculate only the value of A & B...

Date	Classification	Value $
01/01/2023	A	22.00
02/01/2023	B	33.00
03/01/2023	C	32.00
04/01/2023	D	34.00
04/01/2023	E	46.00
06/01/2023	A	75.00
07/01/2023	B	18.00
09/01/2023	C	92.00
10/01/2023	D	1.00
11/01/2023	E	23.00

Expecting all your assistance.

[BrunPierre · Accepted solution]

Hi @D_SARANYA5

This for starters: Set analysis and set expressions 

[D_SARANYA5]

Thank you..... It helps 🙂