topic condition not working in QlikView

condition not working

kishorj1982 — Tue, 14 Nov 2017 07:14:08 GMT

Hi all,

the below condition is not working.Please suggest

Pick(match(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag,

Re: condition not working

shraddha_g — Tue, 14 Nov 2017 07:17:16 GMT

Try

Pick(Wildmatch(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag,

Re: condition not working

Anil_Babu_Samineni — Tue, 14 Nov 2017 07:18:37 GMT

What is this indicated in your match() -- ''

Re: condition not working

kishorj1982 — Tue, 14 Nov 2017 07:21:27 GMT

For all condition need to values for all flags c cp cx and blanks

for active value need to show value for flag c, cp and

for inactive need to show value for flag cx

plz suggest

Re: condition not working

Anil_Babu_Samineni — Tue, 14 Nov 2017 07:26:23 GMT

Try this way

Pick(WildMatch(if(len(trim(Search_Type))=0,'0',Search_Type), 'C','CP','CX','C','CP','CX','0'),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag

Re: condition not working

arvind_patil — Tue, 14 Nov 2017 07:33:49 GMT

Hi Kishor,

May be like this:

If(wildmatch(Search_Type,'C','CP'),'Active',

If(wildmatch(Search_Type,'CX'),'Inactive','All')) as ActiveInactiveFlag,

Thanks,

Arvind Patil

Re: condition not working

kishorj1982 — Tue, 14 Nov 2017 07:51:22 GMT

Hi Arvind,

For All, I nned to show the value for c,cp,cx and blank

Re: condition not working

kishorj1982 — Wed, 15 Nov 2017 04:53:10 GMT

Hi all ,

For Option all need to show values for c cp cx and blanks

for option active value for c, cp need to display and

and for option inactive value for cx need to show in list box.

Please suggest.

PFA.

Re: condition not working

tresB — Wed, 15 Nov 2017 05:05:17 GMT

Your conditions are not mutually exclusives, i.e they overlap. If first condition is true for say 'c' to be 'Active', it would never be true for 'All'. Here you could follow Generic keys that would require multiple loads for Search_Type data.

Re: condition not working

neha_shirsath — Wed, 15 Nov 2017 05:52:43 GMT

Hi,

Please find the attached file.

Re: condition not working

arvind_patil — Wed, 15 Nov 2017 07:40:58 GMT

HI Kishor,

I think neha.shirsath‌ is right her code is working lets check:

test:

LOAD * Inline [

Search_Type

]

;

LOAD *,

If(wildmatch(Search_Type,'C','CP'),'Active',

If(wildmatch(Search_Type,'CX'),'Inactive')) as ActiveInactiveFlag

Resident test;

DROP Table test;

Concatenate

LOAD * Inline

[

Search_Type, ActiveInactiveFlag

C,All

CP,All

CX,All

];

Thanks,

Arvidn Patil

Re: condition not working

effinty2112 — Wed, 15 Nov 2017 08:46:19 GMT

Hi Shraddha,

There's something not right here:

Pick(Wildmatch(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag

If you want a wildmatch you need to use wildcards in your expression so the expression knows exactly how to compare strings. We need to be careful, if you replace 'C' with 'C*' for example then if Search_Type = 'CP' the wildmatch function will not return 2 but 1 because 'C*' is a wildmatch with 'CP'.

Instead of trying to return a value of 7 for a wildmatch with '' take out the '' parameter and add 1 to the wildmatch and rearrange your pick selections.

So instead of something like

Pick(Wildmatch(Search_Type, 'A*','B*','C*',''),'A...','B...','C...', 'Nothing')

Pick(1+Wildmatch(Search_Type, 'A*','B*','C*'),'Nothing','A...','B...','C...')

Good luck

Andrew

Re: condition not working

kishorj1982 — Thu, 16 Nov 2017 12:42:48 GMT

I have concatenated the tables this is not working for all tables.

thanks

Re: condition not working

kishorj1982 — Thu, 16 Nov 2017 13:47:33 GMT

Hi Tresco,

Thanks for the response.But I am not able to understand how it works in my scenario.

Thanks

Re: condition not working

kishorj1982 — Thu, 16 Nov 2017 13:49:37 GMT

This condition is not working for the tables where i used concatenation.

Thanks

Re: condition not working

kishorj1982 — Thu, 16 Nov 2017 16:40:39 GMT

Hi Anil,

This condition is not working.

Thanks,

Re: condition not working

tresB — Fri, 17 Nov 2017 04:43:36 GMT

It would require script modification. Try to share a sample qvw with inline data to mimic your scenario where we can work upon to give you heads-up.

Re: condition not working

neha_shirsath — Fri, 17 Nov 2017 04:46:00 GMT

Okay. It should work, Can you share your sample data set?

Re: condition not working

kishorj1982 — Fri, 17 Nov 2017 05:24:31 GMT

PFA.

Values of all is not matching , whenever I am clearing all selection sum(collection amount) is displayed as per requirement.

Thanks

Re: condition not working

Anil_Babu_Samineni — Fri, 17 Nov 2017 10:51:12 GMT

May be helps Qlik Community Tip: How to Get Answers to Your Post