How to use variable in a Set Analysis

[Anonymous]

The following Set Analysis works.

Sum( {$<[login pass Last Access]={'Feb-17'}>} [login pass Total])

However, I create a variable for field [login pass Last Access] as vLoginPass,

when using the following Set Analysis with the above variable, not working any more

Sum( {$<[login pass Last Access]= {'$(=vLoginPass)'} >} [login pass Total]) , not working

Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total]) , not working

Any suggestion is appreciated!

[ahaahaaha]

Hi Haikou

Maybe so

Sum( {$<[login pass Last Access]= {$(vLoginPass)} >} [login pass Total])  or

Sum( {$<[login pass Last Access]= {$(#vLoginPass)} >} [login pass Total])

Regards,

Andrey

[shraddha_g]

Try

Sum( {$<[login pass Last Access]= {"=$(vLoginPass)"} >} [login pass Total])

Or

Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total])

or

Sum( {$<[login pass Last Access]= {$(vLoginPass)} >} [login pass Total])

[sasiparupudi1]

Variable in script

Set vLoginPass='Feb-17';

Expression

Sum( {$<[login pass Last Access]= {'$(vLoginPass)'} >} [login pass Total])

hth

Sasi

[Anil_Babu_Samineni]

I doubt, Whether you have same format of index / Search / Selectors in your file list for [login pass Last Access]

Can you let us know the format of mentioned Values

[priyasawant]

create variable as vLoginpass=Feb-17

sum({<[login pass Last Access]={$(vLoginPass)}>}[login pass Total]))

i just want to know are you taking Feb-17 from any field or it is static.

if it is dynamic and you are taking the max i.e Feb-17 from the field then you must write

vLoginPass=max(mention the field from where Feb-17 is coming) and then use it in the above mentioned set analysis.