Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the value in the field

How to get the value in the field






















































OrderNoStatus
100123687ABGR ABGS ABRV ADVS
  CCOK CLSD CMPL CNF DRUC GMPS KKMP KPOK NMAT PRT
100162353 KPOK NMAT PRT  RESA RÜCK SETC SSAP TABG TECO TFAK
100162887 CCOK CNF DRUC KKMP  PTBL
100162989 CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK
100162999PRT PTBL RESA RMWB
  RÜCK SETC SSAP TABG TECO TFAK VORA WABE
100163492NMAT PRT PTBL RESA
  RÜCK SETC SSAP TABG TECO TFAK
100164509 KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG
  TECO TFAK
100941788ABGR ABRV ADVS CCOK
  CNF
100946497ABGR ABRV ADVS CCOK
  CNF GMPS KKMP
100950777GMPS KKMP KPOK MANC
  NMAT NMVP  TECO
100950874KPOK MANC NMAT NMVP
  PTBL  TABG TECO
100951880KKMP KPOK PCNF PTBL
  RESA SETC SSAP TABG TECO
100952884ABGR ABRV ADVS CCOK
  CNF GMPS KKMP

OrderNo  Status

100123687 ABGR ABGS ABRV ADVS CCOK CLSD

100162353  KPOK NMAT PRT  SSAP TABG TECO TFAK

100162887  CCOK CNF DRUC KKMP  PTBL

100162989  CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK

100162999 PRT PTBL RESA RMWB RÜCK SETC SSAP TABG TECO TFAK

100163492 NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK

100164509  KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG TECO TFAK

100941788 ABGR ABRV ADVS CCOK CNF

100946497 ABGR ABRV ADVS CCOK CNF GMPS KKMP

100950777 GMPS KKMP KPOK MANC NMAT NMVP  TECO

100950874 KPOK MANC NMAT NMVP PTBL  TABG TECO

100951880 KKMP KPOK PCNF PTBL RESA SETC SSAP TABG TECO

100952884 ABGR ABRV ADVS CCOK CNF GMPS KKMP
























































OrderNoStatus
100123687ABGR ABGS ABRV ADVS
  CCOK CLSD CMPL CNF DRUC GMPS KKMP KPOK NMAT PRT
100162353 KPOK NMAT PRT  RESA RÜCK SETC SSAP TABG TECO TFAK
100162887 CCOK CNF DRUC KKMP  PTBL
100162989 CNF PTBL RESA RÜCK SETC SSAP TABG TECO TFAK
100162999PRT PTBL RESA RMWB
  RÜCK SETC SSAP TABG TECO TFAK VORA WABE
100163492NMAT PRT PTBL RESA
  RÜCK SETC SSAP TABG TECO TFAK
100164509 KPOK NMAT PRT PTBL RESA RÜCK SETC SSAP TABG
  TECO TFAK
100941788ABGR ABRV ADVS CCOK
  CNF
100946497ABGR ABRV ADVS CCOK
  CNF GMPS KKMP
100950777GMPS KKMP KPOK MANC
  NMAT NMVP  TECO
100950874KPOK MANC NMAT NMVP
  PTBL  TABG TECO
100951880KKMP KPOK PCNF PTBL
  RESA SETC SSAP TABG TECO
100952884ABGR ABRV ADVS CCOK
  CNF GMPS KKMP
I need to count the orders which has the status value  ABGR
or   ABGR ABRV  .
another Keyfigure  how many orders which doesn't have ABGR.
I tired match and wildmatch- it is not working.
Advance Thanks for help.
2 Replies
eddysanchez
Partner - Creator
Partner - Creator

you need to use load resident like that:

TableResident:

Load Count(OrderNo) as CountABGR

Resident Table

Where Status = 'ABGR'

or Status = 'ABGR ABRV';

And then peek fuction for asign in a variable:

LET vCountABGR = Peek('CountABGR',0,'TableResident')

Not applicable
Author

using substring count  solve the issue.

Thanks for your help.