topic Write an expression with multiple conditions in QlikView

Write an expression with multiple conditions

gilldilpreet — Sat, 16 Nov 2024 00:00:49 GMT

Hi,

I am trying to write the expression below but it is returning an error.

I would like the calculated dimension to show the Acceptance date WHERE the Paper Type Code =1 and for the highest Paper Number (which is a field that shows paper numbers in sequence i.e. identifies the most recent).

Thanks in advance for any help on this!

Dilpreet

Re: Write an expression with multiple conditions

Kushal_Chawda — Tue, 08 Sep 2020 14:13:03 GMT

@gilldilpreet Can you share sample data with expected output?

Re: Write an expression with multiple conditions

gilldilpreet — Tue, 08 Sep 2020 15:46:27 GMT

Using the data below as an example;

Student ID	Paper Type Code	Paper Number	Acceptance Date
1	1	A01	02/03/2004
1	1	A02	03/03/2004
1	2	A03	04/03/2004
2	1	A05	05/03/2004
2	2	A06	06/03/2004

This is the result I am after;

Student ID	Acceptance Date
1	02/03/2004
2	05/03/2004

Re: Write an expression with multiple conditions

Brett_Bleess — Tue, 22 Sep 2020 21:29:08 GMT

@Kushal_Chawda Poster responded back with sample data and expected output, guessing the notifications may still be having some issues in Community, sorry about that if so. Thanks in advance for checking back.

Regards,
Brett

Re: Write an expression with multiple conditions

Kushal_Chawda — Tue, 22 Sep 2020 21:45:42 GMT

@gilldilpreet try below expression

=aggr(if([Paper Number]= maxstring(total <[Student ID]>{<[Paper Type Code]={1}>}[Paper Number]),[Acceptance Date]),[Student ID],[Paper Type Code],[Paper Number])