topic Re: if condition in QlikView

if condition

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

is it possible to have like an if condition as below

if(match(country name, then A and B else C

C are 3 different values in one table.

Re: if condition

YoussefBelloum — Mon, 08 Jan 2018 11:04:05 GMT

Hi,

you want to do it on the script or on the charts ?

and A, B and C are values or fields ?

Re: if condition

Chanty4u — Mon, 08 Jan 2018 11:06:44 GMT

try this

=PICK(Match(CountryName, 'A','B','C') 'A','B','C')

Re: if condition

raadwiptec — Mon, 08 Jan 2018 12:00:16 GMT

it should be in the script only..

Re: if condition

Anil_Babu_Samineni — Mon, 08 Jan 2018 12:03:15 GMT

Chanty, What is the use of this? I believe this returns same as from Field

Re: if condition

Anil_Babu_Samineni — Mon, 08 Jan 2018 12:03:33 GMT

What you want to do so in script?

Re: if condition

sunny_talwar — Mon, 08 Jan 2018 12:09:13 GMT

Re: if condition

sunny_talwar — Mon, 08 Jan 2018 12:09:32 GMT

Would you be able to elaborate your requirement with an example?

Re: if condition

raadwiptec — Mon, 08 Jan 2018 12:52:06 GMT

hi all,

I need to hard coded values

is it possible to have like an if condition as below

if(match(country name, France then 'Legal' ,'processed' else 'unauthorized'

The above is working only for one output ex: legal. i require both..

Legal

processed

unauthorized

are 3 different hard coded values in one table. so when i select country --france in the report in another list box i should see below as 2 different values as because in the data model the below 2 value exists in another linked way

legal

processed.

Re: if condition

Anil_Babu_Samineni — Mon, 08 Jan 2018 12:56:24 GMT

on what bases you want to pick one another one? Could u describe more

Re: if condition

sunny_talwar — Mon, 08 Jan 2018 12:59:02 GMT

So basically if the Country name is France, you want to create two rows for it... one with the value Legal and the second one with processed?

May be try with link table

LinkTable:

LOAD DISTINCT [Country name],

If([country name] = 'France', 'Legal', 'unauthorized') as Flag

Resident ....;

Concatenate (LinkTable)

LOAD [country name],

'processed' as Flag

Resident ...

Where [country name] = 'France';