topic Re: if statement in App Development

if statement

krmvacar — Thu, 04 Mar 2021 19:45:52 GMT

Hi,

I'm trying to rank hierarchies and I'm trying to write dimension.

Level=1 Manager,Level=2 Manager Helper ,Level=3 Employee

if selected level 1 show me level 2 names.

=if (LEVEL=2,if(LEVEL=1 and PRED=WORKNUM,NAME))

its not work:(

please help

Re: if statement

joaopaulo_delco — Thu, 04 Mar 2021 19:52:26 GMT

Hi @krmvacar

Try this:

If(LEVEL = 1,'Manager',
if(LEVEL = 2,'Manager Helper',
if(LEVEL = 3, 'Employee')))

Re: if statement

krmvacar — Thu, 04 Mar 2021 20:09:43 GMT

Hİ @joaopaulo_delco

sorry I could not explain.I want to create a dimension in the pivot table here.

when i create dimension if level=2 only show under john angelina and oleg.

Re: if statement

joaopaulo_delco — Thu, 04 Mar 2021 21:31:54 GMT

@krmvacar I don't know if it's possible do it directly at pivot table.

Maybe you have to consider do it in the script.

The way of your table is structured, you can use the "Org chart" like below:

Re: if statement

krmvacar — Thu, 04 Mar 2021 22:32:33 GMT

Thank you so much @joaopaulo_delco ı need dimension or script.

Re: if statement

joaopaulo_delco — Fri, 05 Mar 2021 11:55:03 GMT

@krmvacar, if it solve your problem, can you accept my post as solution?

Re: if statement

PrashantSangle — Fri, 05 Mar 2021 13:05:28 GMT

check hierarchy() and hierarachybelongsto() in qlik help menu

Regards,

Re: if statement

krmvacar — Fri, 05 Mar 2021 17:43:27 GMT

İts not solve sorry:(

Re: if statement

Saravanan_Desingh — Fri, 05 Mar 2021 18:30:02 GMT

Try this,

tab1: Hierarchy(Work#, Pred, Name,,Name) LOAD * INLINE [ Work#, Name, Level, Pred 11246, John, 1, 19835, Angel, 2, 11246 12939, Vick, 3, 19835 34565, Oleg, 2, 11246 ];

Re: if statement

Saravanan_Desingh — Fri, 05 Mar 2021 18:30:25 GMT

Output:

Re: if statement

krmvacar — Fri, 05 Mar 2021 18:57:38 GMT

Thank you so much.its ok