topic Re: Set in QlikView

Set

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

Hi All,

Iam trying to executive the below expression this is not working

Iam facing difficulties ..

Please correct me ....

=if(NOT MATCH([When Found],'(ST) System Test','(CVT) Customer Validation Test','(FFT) Feature Function Test','(RT) Regression Test'),count(distinct{ <LoadDate = {"$(=Max(LoadDate))"}>}Key))

Re: Set

sunny_talwar — Tue, 24 Oct 2017 08:36:40 GMT

Try this

=Count(DISTINCT {<LoadDate = {"$(=Max(LoadDate))"}, [When Found] -= {'(ST) System Test', '(CVT) Customer Validation Test', '(FFT) Feature Function Test', '(RT) Regression Test'}>} Key)

Re: Set

smilingjohn — Tue, 24 Oct 2017 09:04:56 GMT

Hi Sunny ,

look this is how i get this with red mark

As shown in the figure

Why is this highlighted in red alert ????

Is this a wrong way of writing

Re: Set

smilingjohn — Tue, 24 Oct 2017 09:12:40 GMT

Hi Sunny ,

In this expression should also count the blank values present in the When found field..

Currently it is excluding the blank values of When found Field.

Please find the attachment of the screenshot .. of the field whenfound .. here you can see there is only production present and rest are blank .

i want to count that also ..

how do i do this with the existing expression ..

=count(distinct {<LoadDate = {"$(=Max(LoadDate))"},[When Found] -= {'(ST) System Test','(CVT) Customer Validation Test','(FFT) Feature Function Test','(RT) Regression Test'}>}Key)

Re: Set

sunny_talwar — Tue, 24 Oct 2017 11:08:54 GMT

May be create a flag in the script....

If(Match([When Found], '(ST) System Test', '(CVT) Customer Validation Test', '(FFT) Feature Function Test', '(RT) Regression Test'), 0, 1) as Flag

and then use this

=Count(DISTINCT {<LoadDate = {"$(=Max(LoadDate))"}, Flag = {1}>} Key)