Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Hi Malek
This is what I am getting.
Regards,
Kumar.
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.
This QVW and QVD file sizes are big size .
Regards,
Kumar
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.
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.
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]))
Can you find the screen shot after modifying the expression
Reddy, I did not the {} brackets around PPC. Please remove those and test again.