Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kiranb13
New Contributor II

Selecting the first instance of the id status

Hi,

 

I have the below following data.

Test IDRun IDResult
11Passed
12Passed
13Failed
14Blocked 
15NA
26Failed
27Passed
28Passed
39NA
310Passed
311Passed
412Passed
413Passed
514Failed
515Passes
516NA

 

I need the count of the test passed and failed the column TestId for the 1st instance in RunId. Other than these two status i need to ignore that particular row.

Expected Result :

Count of Passed=2
Count of failed=2

 

 

9 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Selecting the first instance of the id status

See attached example


talk is cheap, supply exceeds demand
kiranb13
New Contributor II

Re: Selecting the first instance of the id status

Hi Gysbert,
I am not able to get the result for the above expression.

Re: Selecting the first instance of the id status

What are you getting and what are you looking to get when you use @Gysbert_Wassenaar expression and calculated dimension?

kiranb13
New Contributor II

Re: Selecting the first instance of the id status

Data is not getting displayed, it's completely empty straight table. FirstSortedValue.PNG

 

 

Re: Selecting the first instance of the id status

It might be easier if you are able to share a sample to show what is going on?

kiranb13
New Contributor II

Re: Selecting the first instance of the id status

FTR.PNG

Hi Sunny,

Above is requirement. 

FTR=(No of TC's passed/(No of TC's passed+No of TC's failed))

I need TC's status Passed or Failed count at 1st instance.

Re: Selecting the first instance of the id status

okay, sounds good

kiranb13
New Contributor II

Re: Selecting the first instance of the id status

Hi Sunny,

Did you get any chance to look into the above scenario ?

Re: Selecting the first instance of the id status

Where do I need to look? I didn't see any sample attached? Am I missing something?