dimension value in expressions

[#1]

Hello,

      Everyone,  for somereason,  I need the DATA STRUCTURE in my test qv.

So why could't I make the value out?  And how to modify my expression ?

Please see the attchment.

!

[Anonymous]

Hi,

Not sure if I Understand but I will give it a try and hopefully this helps.

If you open the test file and press CTRL + T you will notice the two tables are not associated - No association line is present. It requires the same field names in both tables to link them up.

If you select "F" as the dimension and "sum(V)" as your expressions, the values will show up.

If you would like to create the link between the two tables:

in script:

t2:
LOAD Distinct F  Resident t1;

Now press CTRL + T and see the linkage/Association.

If I have not understood your requirement, please try and explain with more detail so we can help you.

[prabiradhikary]

you can use :

sum({<F={$(=concat(distinct F,','))}>}V)

[HirisH_V7]

What is the  output you want to see from your Expression!!

[#5]

[HirisH_V7]

Hi,

Check this,by using this expression,

Sum({<F={$(=concat(distinct F1,','))}>}V)

PFA,

HTH,

Hirish

[#7]

thanks,hirishv7‌,but it's not suit for this case.

[avinashelite]

Why don't you link the F and F1 in the script that solves the problem rite ?? any specific reason not to link those ??

Table1;

LOAD

F

V

table2:

LOAD F1 as F

[#9]

[HirisH_V7]

Can you explain a bit more about your'e requirement.