Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Logic needed

Hi,

Below is my data structure

ID   Status                     Amt

1    Active                       234

1    Completed                211

2    Active                       2000

3    Completed                400

If ID has Active and Completed count only ID with Active else count other status...

I want the below output

ID   Status                     Amt

1    Active                       234

2    Active                       2000

3    Completed                400

Thank you much.

3 Replies
prma7799
Master III
Master III

Like this you want

shiveshsingh
Master
Master

i.e for ID = 1 you want only Active to be loaded as status in script?

Do you have any reference date column also?

apthansh
Creator
Creator
Author

This out put has 2 rows for ID 1..I only want Active ID if its both Active and Completed.