Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kiranb13
New Contributor III

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

Re: Selecting the first instance of the id status

See attached example


talk is cheap, supply exceeds demand
kiranb13
New Contributor III

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 III

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 III

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 III

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?

Community Browser