topic Re: set analysis in QlikView

set analysis

Anonymous — Thu, 14 May 2015 04:42:09 GMT

Hi,

Is any thing wrong in this expression. Pls help me

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

Re: set analysis

Anonymous — Thu, 14 May 2015 04:47:04 GMT

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

Re: set analysis

Anonymous — Thu, 14 May 2015 04:51:00 GMT

I have to use text function in set analysis

Re: set analysis

vardhancse — Thu, 14 May 2015 05:37:56 GMT

What is the value for Campaign Channel field

Re: set analysis

PrashantSangle — Thu, 14 May 2015 05:41:12 GMT

Hi,

Try

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

Regards

Re: set analysis

tresB — Thu, 14 May 2015 05:47:46 GMT

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.

Re: set analysis

Anonymous — Thu, 14 May 2015 05:48:05 GMT

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

Re: set analysis

Anonymous — Thu, 14 May 2015 05:49:39 GMT

Can't we use this functions directly in set analysis

Re: set analysis

tresB — Thu, 14 May 2015 05:56:32 GMT

No. Not on the LHS.

Re: set analysis

ToniKautto — Thu, 14 May 2015 06:13:20 GMT

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

Re: set analysis

vinod2086 — Thu, 14 May 2015 07:23:25 GMT

Hi Kumar,

instead of using set analysis you can use match function na

try this

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

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

Re: set analysis

qlikviewwizard — Thu, 14 May 2015 08:59:18 GMT

Hi kumarreddy257,

Did you resolve the issue?

Re: set analysis

Anonymous — Thu, 14 May 2015 12:06:32 GMT

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

Re: set analysis

Anonymous — Thu, 14 May 2015 12:06:43 GMT

No.

Re: set analysis

PrashantSangle — Thu, 14 May 2015 12:10:35 GMT

Hi,

have you tried earlier suggestions...???

Try

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

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

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

Regards