set analysis

[Anonymous]

Hi,

Is any thing wrong in this expression. Pls help me

Count(text([Campaign Channel])='PPC')[Site Visit Vis Num]

[vinod2086]

Hi Kumar,

instead of using set analysis you can use match function na

try this

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

or

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

[qlikviewwizard]

Hi kumarreddy257,

Did you resolve the issue?

[Anonymous]

I have to do sum of Site Visit Vis Num where campaign channel is PPC. But in your statement it is showing only site Visit Vis Num

[Anonymous]

No.

[PrashantSangle]

Hi,

have you tried earlier suggestions...???

Try

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

or

Sum(if(wildmatch([Campaign Channel],'PPC'),[Site Visit Vis Num]))

or

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

Regards