set analysis

[Anonymous]

Hi,

Is any thing wrong in this expression. Pls help me

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

[Anonymous]

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

[Anonymous]

I have to use text function in set analysis

[vardhancse]

What is the value for Campaign Channel field

[PrashantSangle]

Hi,

Try

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

Regards

[tresesco]

Two issues:

• Improper expression (syntax/structure) - the correct way of set analysis expression is -  Count({<[Campaign Channel]={'PPC'}>}[Site Visit Vis Num])
• Improper Set Expression syntax - Count({<Text([Campaign Channel])={'PPC'}>}[Site Visit Vis Num]) - left hand side of set expression can only be a script generated field , so no function can be used like text().

Instead you can create a field in the script with text() and use that in set expression like:

Load

          Text([Campaign Channel]) as TextChannel

              ....

Then, Count({<TextChannel={'PPC'}>}[Site Visit Vis Num])

Or,

try with simple IF statement.

[Anonymous]

In Qvx target file data type is unknown, but campaign channel is char.

[Anonymous]

Can't we use this functions directly in set analysis

[tresesco]

No. Not on the LHS.

[ToniKautto]

A set expression contains set modifiers, which efficiently are equal to selections. The text you define in the set modifier, will apply a selection in the same way as if it was a search string. Naturally a search string like "=Text(MyValue)" will search for the value "=Text(MyValue)" and not the result you would get if the function was evaluated.

You can accomplish a calculation in the set modifier by using dollar expansion, but this require that you consider how the expansion is made.

Set expression and dollar expansion