Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

Fetch Inner value of the flag in Set anlaysis

Hi,

I have a condition with flag 0,1

If(360>=0 and 360<=8,1,0) as 360woh

I'm trying to fetch the value of the Dimension "360woh" values where flag =1

But it fetches the value "1" but not its corresponding values

Can anyone look into it.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Fetch Inner value of the flag in Set anlaysis

Hey Mark, try this (not sure if it will work but no harm trying:

=Only({<360woh = {1}>} 360)

4 Replies
MVP
MVP

Re: Fetch Inner value of the flag in Set anlaysis

Hey Mark, try this (not sure if it will work but no harm trying:

=Only({<360woh = {1}>} 360)

ramoncova06
Valued Contributor III

Re: Fetch Inner value of the flag in Set anlaysis

you need to assigned another field and do this, since at the moment all you are doing is creating a flag for it


If(360>=0 and 360<=8,360,0) as 360wohvalue

Highlighted
markgraham123
Contributor II

Re: Fetch Inner value of the flag in Set anlaysis

It worked.

Sorry sunny, when u sent me the code, i was typing incorrectly.

Its my mistake.

MVP
MVP

Re: Fetch Inner value of the flag in Set anlaysis

No big deal Mark.

I am glad it is working now

Best,

Sunny