topic Re: Select only the latest value of item in QlikView

Select only the latest value of item

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have been currently working on a sales table with some key algorithms

Data Source
Date	Brand	Status	Salesman
1/1/2018	A	0	S
1/2/2018	A	0	S
1/3/2018	B	1	S
1/4/2018	B	0	S
1/5/2018	B	1	S
1/1/2018	A	1	j
1/2/2018	A	0	j
1/3/2018	B	0	j
1/4/2018	B	0	j
1/5/2018	B	0	j

In the data set above.the sales manager has a desire to see only the status '1' for each salesman and brand in the selected period. If the sales manager selects a period from 1/1/2018 to 1/5/2018,

Table becomes

Start Date

1/1/2018

End Date

1/5/2018

Brand
Salesman	A	B
S	0	1
J	1	0

and when he selects 1/1/2018 to 1/1/2018

The table becomes

Start Date	1/1/2018	End Date	1/1/2018
Brand
Salesman	A	B
S	0	0
J	1	0

Can you kindly share your thoughts?

Re: Select only the latest value of item

jonathandienst — Thu, 30 Aug 2018 06:23:26 GMT

This should be the out of the box behaviour of a pivot table in Qlik. This can be by the user selecting Status = 1, or using it in a set expression like Status = {1}. Use Salesman, Brand as dimensions and Count({<Status = {1}>} Brand) as the expression.

Re: Select only the latest value of item

boraste-sagar — Thu, 30 Aug 2018 07:07:50 GMT

in the expression just pass this expression

if( Status= 1, Status)

if u dont want status to be printed then

if( Status= 1, 'Pas') that means in front of a and b when status =1 then Pass will be printed

Re: Select only the latest value of item

boraste-sagar — Thu, 30 Aug 2018 07:14:46 GMT