Trying to use a variable In Set Analysis

[narband2778]

Hello Everyone,

I have created a Variable in the Variables

vCurrentSelection =SubField(GetCurrentSelections(), ':',2)

and now I am trying to use the variable in Set analysis, but it is not working

=Count({<[Session  Name] = {"$(=vCurrentSelection)"}>}[Session  Name])

Can someone help me with this.

thanks in advance.

Naresh

[sunny_talwar]

$Field is a system generated field which stores all the field names in your dashboard.... You can add it as a dimension by typing it out.

I have created a small sample for you to check out.

Sample data

Table:

LOAD * INLINE [

    Field1, Field2, Field3, Field4

    XYZ, JAB, ASH, XYZ

    DEF, KKL, JJA, KKL

    JAB, AHH, XYZ, XYZ

];

[sunny_talwar]

Look here for $Field and other system generated fields

system fields

[narband2778]

Thanks Sunny Paaji... Worked absolutely fine.

Learnt couple of things from you today.

Thanks,

Naresh

[sunny_talwar]

I am glad I was able to help you out