topic Re: dimension value in expressions in QlikView

dimension value in expressions

Thu, 27 Oct 2016 04:41:36 GMT

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.

Re: dimension value in expressions

Anonymous — Thu, 27 Oct 2016 06:35:53 GMT

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.

Re: dimension value in expressions

prabiradhikary — Thu, 27 Oct 2016 07:12:49 GMT

you can use :

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

Re: dimension value in expressions

HirisH_V7 — Thu, 27 Oct 2016 08:35:59 GMT

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

Re: dimension value in expressions

Thu, 27 Oct 2016 08:38:28 GMT

Re: dimension value in expressions

HirisH_V7 — Thu, 27 Oct 2016 08:54:32 GMT

Hi,

Check this,by using this expression,

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

PFA,

HTH,

Hirish

Re: dimension value in expressions

Thu, 27 Oct 2016 09:00:31 GMT

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

Re: dimension value in expressions

avinashelite — Thu, 27 Oct 2016 09:10:30 GMT

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

table2:

LOAD F1 as F

Re: dimension value in expressions

Thu, 27 Oct 2016 09:13:46 GMT

Re: dimension value in expressions

HirisH_V7 — Thu, 27 Oct 2016 09:15:24 GMT

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