Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

Set analysis issue

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

1 Solution

Accepted Solutions

Re: Set analysis issue

Why so much moderated post??

12 Replies
Employee
Employee

Re: Set analysis issue

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

kumarreddy257
Contributor

Re: Set analysis issue

Hi Clever,

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

Regards,

Kumar

Digvijay_Singh
Honored Contributor III

Re: Set analysis issue

try this -

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

Re: Set analysis issue

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

Why so much moderated post??

MVP
MVP

Re: Set analysis issue

Which dimensions do you have in your chart?

Employee
Employee

Re: Set analysis issue

Weird, works fine here

kumarreddy257
Contributor

Re: Set analysis issue

No Use Digvijay.

Employee
Employee

Re: Set analysis issue

Community Browser