topic Re: Problem in Filtering data in Set Analysis in QlikView

Problem in Filtering data in Set Analysis

Anonymous — Fri, 08 Jul 2016 05:34:29 GMT

I have data where i have three columns:

a | b | c

I want to write set analysis to calculate avg of c when b <> "text1/text2". Where (text1/text2) is just text in column b.

Here the value i am comparing has "/", i think that is creating problem in comparison.

I am writing set analysis as given below and its not working:

avg({<b-={'text1/text2'}>}c)

Can anyone please help me with this, I am stuck here.

Thanks

Fri, 08 Jul 2016 07:51:20 GMT

Try without single quotes:

avg({<b-={(text1/text2)}>}c)

Alternatively, create field "Text3" (=text1/text2) in script and use that field in the set:

avg({<b-={text3}>}c)

Regards,

Pravesh

Chanty4u — Fri, 08 Jul 2016 08:00:28 GMT

try this

avg({<b-={(text1/text2)}>}c)

Anonymous — Fri, 08 Jul 2016 08:04:31 GMT

Thanks Pravesh,

But this solution doesn't seem to work since text1 and text2 are not columns.

text1/text2 is just some random text (text1 and text2 are not columns).
for eg. "sumit/sahu"

Anonymous — Fri, 08 Jul 2016 08:06:49 GMT

it says error in expression since text1 and text are not columns, its just random text.

eg: x/y

Fri, 08 Jul 2016 10:19:53 GMT

In that case, what is the logic of text1/text2?

boorgura — Fri, 08 Jul 2016 13:26:05 GMT

Please try this:

avg({<b={"*"} - {'text1/text2'}>}c)

sunny_talwar — Fri, 08 Jul 2016 15:02:28 GMT

I don't think '/' should cause any issues, but try this may be:

Avg({<b -= {'text1*text2'}>} c)

Where * is used a wildcard to replace '/'