Possible Multiple If condition

[Anonymous]

Hi,

I need help.  I have transaction data that are in group Tender Board A, Tenders Board B, Tenders Board C. In which have approving authority (name 1 ,name 2,name 3)     

transaction Number	Tender	Name 1	Name 2	Name 3
0000000001	Tender Board A	Roy	Charanjit	Penn
0000000002	Tenders Board B	Penn	Mun	Ling
0000000003	Tenders Board B	Penn	Mun	Charanjit
0000000004	Tenders Board B	Penn	Mun	Ling
0000000005	Tender Board C	Paul	Charanjit	Mun
0000000006	Tender Board C	Paul	Steph	Annie
0000000007	Tender Board C	Ling	Steph	Annie
0000000008	Tender Board A	Roy	Mun	Charanjit

In my qlikview, I have an image(text box) which will appear if conditions is made.

The CONDITIONS are:

User Selected transaction number,

    If is group "Tenders Board C", Annie and Steph IS NOT in the 3 names, the image will appear,

    If is group "Tenders Board B", Ling IS NOT in the 3 names, the image will appear,

    If is group "Tender Board A", Ling IS NOT in the 3 names, the image will appear,

RESTRICTIONS:

The expression should be in the text box and not the script as originally the name are generated after running the script.

Attach are the data, same as the table above.

I am unable to view .qvw due to personal edition. A screenshot is kindly appreciated

[Anonymous]

hi,

my script included CrossTable(NO, Name,2)

Still it is not working. Only BOX C is working.

[Anonymous]

Hey, I tried the coding into my original project and it works! Thanks!

If I were to change the name to wildmatch type (instead of full name "LING", I wanna wildmatch for "NG") how do I change it?

[MK_QSL]

Kindly close the thread...

For wildmatch use *NG

[Anonymous]

HI, so it will write as

IF(GetSelectedCount(Tender) = 0 and GetSelectedCount([transaction Number])=0, 0,

IF(SubStringCount(Concat(DISTINCT Tender,','),'Tender Board A')=0,0,

IF(SubStringCount('|'&Upper(Concat({<Tender = {'Tender Board A'}>}DISTINCT Name, '|')&'|'),'|*NG*|')=0,0,1)))

?