Solved: Re: Problem with expression - Qlik Community

Anonymous · ‎2015-03-26

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

anbu1984 · ‎2015-03-26

Try after removing these brackets

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

View solution in original post

PrashantSangle · ‎2015-03-26

Hi,

Remove extra ()

Try below

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

anbu1984 · ‎2015-03-26

Try after removing these brackets

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

Anonymous · ‎2015-03-26

Thanks a lot. It's working