Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kumarreddy257
Contributor

Prblem in Set Analysis logic

Hi,

I am new to Qlikview and facing strange issue with small set analysis expression

This is my expression

SUM({<[Campaign Channel]={'PPC'}>}[Site Visit Vis Num])


Actually there is data for campaign channel and as well for Site Visit Vis Num as I checked individually.

If I combine as expression it is returning '0' for all dates.

Can anybody help me how to resolve this issue. Thanks in advance

Regards,

Kumar

30 Replies
maleksafa
Valued Contributor

Re: Prblem in Set Analysis logic

if you change the expression to SUM([Site Visit Vis Num]) and add a listbox for Campaign Channel, then select PPC what will you get?

kumarreddy257
Contributor

Re: Prblem in Set Analysis logic

Hi Malek

This is what I am getting.

Regards,

Kumar.

maleksafa
Valued Contributor

Re: Prblem in Set Analysis logic

i can't see anything wrong about the expression then, just double check if the dimension name is correct.

can you upload a sample document, i can help you more.

kumarreddy257
Contributor

Re: Prblem in Set Analysis logic

This QVW and QVD file sizes are big size .

Regards,

Kumar

Not applicable

Re: Prblem in Set Analysis logic

Can you TRIM the ChannelCount in the script, I guess PPC is having leading spaces.

Also cross check the field name, I can see Channel Count and Campaign Channel fields.

kumarreddy257
Contributor

Re: Prblem in Set Analysis logic

Hi Angad,

I have trimmed it still it is having zero's. Campaign channel and Channel count both are same.

For all campaign channels it is having same problem.

Not applicable

Re: Prblem in Set Analysis logic

The set analysis expression looks good.

Can you try IF statement for testing?

sum(if(Campaign Channel = 'PPC',[Site Visit Vis Num]))

or

if(Campaign Channel = 'PPC',sum([Site Visit Vis Num]))

kumarreddy257
Contributor

Re: Prblem in Set Analysis logic

Can you find the screen shot after modifying the expression

Not applicable

Re: Prblem in Set Analysis logic

Reddy, I did not the {} brackets around PPC. Please remove those and test again.