Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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

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

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

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.

Re: Fetch Inner value of the flag in Set anlaysis

No big deal Mark.

I am glad it is working now

Best,

Sunny

Community Browser