topic Re: if statement problem in QlikView

if statement problem

Anonymous — Wed, 04 Mar 2015 11:57:07 GMT

hi gurus,

i have field unit

Unit
USA
CANADA
CHINA
JAPAN
INDIA

a. Operational Americas: Operating units – Only (USA , Canada )
b. Operational International: Operating units – Not (USA, Canada, China , Japan)
c. Operational Global: Operating Units – Not (China, Japan)

how to achieve this in list box

Thanks in advance

Re: if statement problem

anbu1984 — Wed, 04 Mar 2015 12:02:47 GMT

Can you explain your requirement and post expected output in Listbox

Re: if statement problem

Anonymous — Wed, 04 Mar 2015 12:10:59 GMT

Unit
Operational Americas
Operational International
Operational Global

Please find the above out put sample

If i select Operational Americas , USA and CANADA should show

if i select Operational International, INDIA Only should show

if i select Operational Global, USA,CANADA,INDIA Should show

List box should show only above output sample

Re: if statement problem

Gysbert_Wassenaar — Wed, 04 Mar 2015 12:26:22 GMT

Create a new field Operational Group. Add this to the script:

Operational_Groups:

LOAD * INLINE [

Operational Group, Unit

Operational Americas, USA

Operational Americas, CANADA

Operational International, INDIA

Operational Global, USA

Operational Global, CANADA

Operational Global, INDIA

];

Reload the document.

Add a listbox with the new field Operational Group.

Re: if statement problem

robert_mika — Wed, 04 Mar 2015 12:26:28 GMT

T2:

LOAD * INLINE

[

Unit

USA

CANADA

CHINA

JAPAN

INDIA

];

T1:

LOAD * INLINE

[

Oper

Operational Americas

Operational International

Operational Global

]

=if(GetFieldSelections(Oper)='Operational Americas','Only (USA , Canada )',

if(GetFieldSelections(Oper)='Operational International','Not (USA, Canada, China , Japan)',

if(GetFieldSelections(Oper)='Operational Global','Not (China, Japan)')))

Re: if statement problem

Wed, 04 Mar 2015 12:33:30 GMT

you could write an expression in listbox:

scroll to the end of the fields and select expression, in edit box put the following:

If( Unit = 'USA' or Unit = 'Canada', 'Operational Americas',

If( Unit = 'India', 'Operational International',

If( Unit <> 'Japan' and Unit <> 'China' , 'Operational Global')))

Re: if statement problem

Anonymous — Wed, 04 Mar 2015 13:03:00 GMT

Hi ,

Write the below code in script level then u can archive u r desired result

If(Unit='USA' or Unit='CANADA','Operational Americas',
If(Unit<>'USA'or Unit<>'CANADA' or Unit<>'CHINA'or Unit='JAPAN','Operational International',
If(Unit<>'CHINA'or Unit='JAPAN','Operational Global'))) as NEWUNIIT

Re: if statement problem

Anonymous — Wed, 04 Mar 2015 13:40:51 GMT

Hi Guys,

Thanks for your time,

I have 40 + units in my Database ,which option is gud.

Inline is working fine

thanks

Re: if statement problem

robert_mika — Wed, 04 Mar 2015 14:25:43 GMT

If you do not have mapping between those columns it will be hard to find ideal solution.

Gysbert's solution is most dynamic from all of those suggested.

Re: if statement problem

Anonymous — Mon, 09 Mar 2015 13:27:18 GMT

Hi GURUS,

Thanks for your Time,I implemented Gysbert methods,I am able to achieve desired result

Thanks,