Prblem in Set Analysis logic

[Anonymous]

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

[maleksafa]

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?

[Anonymous]

Hi Malek

This is what I am getting.

Regards,

Kumar.

[maleksafa]

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.

[Anonymous]

This QVW and QVD file sizes are big size .

Regards,

Kumar

[#6]

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.

[Anonymous]

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.

[#8]

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]))

[Anonymous]

Can you find the screen shot after modifying the expression

[#10]

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