topic Re: Set analysis issue in QlikView

Set analysis issue

Anonymous — Wed, 07 Oct 2015 12:35:40 GMT

Hi,

I have one issue in with this kind of values in set analysis.

=count(DISTINCT{$<[page]={'www:cart:cloud:complete'},[Campaign Channel]={'Direct Load'},[Site Visit Hit Source]=-{5,7,8,9}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

I am getting one value. If i remove [page]={'www:cart:cloud:complete'} this from set analysis there is no change in the result. But if I select this value from list box it is getting change. Is there any way to handle this www:cart:cloud:complete.

Pls help me on this issue.

Regards,

Kumar

Re: Set analysis issue

Clever_Anjos — Wed, 07 Oct 2015 12:43:22 GMT

just guessing: try using double quotes "www:cart:cloud:complete"

Re: Set analysis issue

Anonymous — Wed, 07 Oct 2015 12:46:22 GMT

Hi Clever,

Thanks for ur quick reply. I tried with that also, but no use.

Regards,

Kumar

Re: Set analysis issue

Digvijay_Singh — Wed, 07 Oct 2015 12:49:54 GMT

try this -

[page]={"=[page]='www:cart:cloud:complete'"}

Re: Set analysis issue

rubenmarin — Wed, 07 Oct 2015 12:50:59 GMT

Hi Kumar, seems set analysis isn't working at least for page field, can you confirm if the name of the field is 'page' or 'Page' (uppercased 'P')

Re: Set analysis issue

rubenmarin — Wed, 07 Oct 2015 12:51:58 GMT

Why so much moderated post??

Re: Set analysis issue

petter — Wed, 07 Oct 2015 12:52:56 GMT

Which dimensions do you have in your chart?

Re: Set analysis issue

Clever_Anjos — Wed, 07 Oct 2015 12:57:25 GMT

Weird, works fine here

Re: Set analysis issue

Anonymous — Wed, 07 Oct 2015 12:57:51 GMT

No Use Digvijay.

Re: Set analysis issue

Clever_Anjos — Wed, 07 Oct 2015 12:59:36 GMT

Would you mind sharing your qvw?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Set analysis issue

pamaxeed — Wed, 07 Oct 2015 13:01:15 GMT

you tried using wildcards?

=count(DISTINCT{$<[page]={'*complete'},[Campaign Channel]={'Direct Load'},[Site Visit Hit Source]=-{5,7,8,9}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

Re: Set analysis issue

Wed, 07 Oct 2015 13:05:57 GMT

As suggested by my fellow friends, you must try double quotes or wildcards.

Also, why we are wrapping the "page" column with square brackets? Check if the column from background is coming with brackets or not.

Can you create a sample file and attach for us.

Thanks,

Singh

Re: Set analysis issue

Anonymous — Wed, 07 Oct 2015 13:15:06 GMT

Hi,

Thanks a lot. Instead of capital P, I am using small p.

Regards,

Kumar