Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rpayn01215
Creator
Creator

Flag the line that doesn't meet a conditon

Hey fellow Qlikkers,

I got another one today that I'm having a hard time with in the script. I want to flag the below highlighted field with a 1. The reasoning behind it is that the line item only has an 'E' in the last column. I need this for both situations, whether the line item only has an 'E' or a 'Q'. We'll want to toss lines out that have both Es and Qs. The flag of 1 is only needed for those lines that don't have both.

I've attached the excel sheet and a qvw. Thanks a lot! I may have a backup plan if we can't get this one.

falg.PNG

1 Solution

Accepted Solutions
sunny_talwar

Try this:

BYAH:

LOAD PO#,

     PO_Item,

     AcctDoc,

     AcctLine,

     DollarValue,

     DollarValueAcct,

     PO_History_Cat

FROM

FlagTheLine.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join (BYAH)

LOAD PO_Item,

  If(Count(DISTINCT PO_History_Cat) = 1, 1, 0) as Flag

Resident BYAH

Group By PO_Item;


Capture.PNG

View solution in original post

5 Replies
swuehl
MVP
MVP

If you only have two categories,try something like

LEFT JOIN (YourTable)

LOAD

     If(Count(DISTINCT PO_History_Cat) =1,1) as Flag

     PO#,

     PO_Item

RESIDENT YourTable

GROUP BY   PO#,     PO_Item;

sunny_talwar

Try this:

BYAH:

LOAD PO#,

     PO_Item,

     AcctDoc,

     AcctLine,

     DollarValue,

     DollarValueAcct,

     PO_History_Cat

FROM

FlagTheLine.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join (BYAH)

LOAD PO_Item,

  If(Count(DISTINCT PO_History_Cat) = 1, 1, 0) as Flag

Resident BYAH

Group By PO_Item;


Capture.PNG

rpayn01215
Creator
Creator
Author

Thanks, Sunny!

rpayn01215
Creator
Creator
Author

i feel like PO# is def needed in the load here for use with the entire dataset.

sunny_talwar

I agree, since your data only had one PO#, i missed to include it, but real data may require you to add PO# to make the row line unique for performing the count