Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

Problem with expression

Hi

Can anybody help me how to make it correct below expression

SUM(TOTAL({<[Campaign Channel]={'PPC'},[Geography Country]={'usa'}>}[Site Visit Vis Num]))

Regards,

Kumar

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Problem with expression

Try after removing these brackets

SUM(TOTAL ( {<[Campaign Channel]={'PPC'},[Geography Country]={'usa'}>}[Site Visit Vis Num]))

3 Replies

Re: Problem with expression

Hi,

Remove extra ()

Try below

SUM(TOTAL {<[Campaign Channel]={'PPC'},[Geography Country]={'usa'}>}[Site Visit Vis Num])

Regards

Regards,
Prashant Sangle
anbu1984
Honored Contributor III

Re: Problem with expression

Try after removing these brackets

SUM(TOTAL ( {<[Campaign Channel]={'PPC'},[Geography Country]={'usa'}>}[Site Visit Vis Num]))

kumarreddy257
Contributor

Re: Problem with expression

Thanks a lot. It's working

Community Browser