topic Re: Problem with expression labels in QlikView

Problem with expression labels

Wed, 25 May 2011 13:39:27 GMT

Hello everyone,

I have a data like this it's a world wide customer data of a company

I'm making a straight table based on customer countries and locations

I want separate label of country name for each colomm

When I'm trying to label my customer countries by using a set variable in script it's not showing any error and at the same time it's not giving me any output

My expression on script side is this

For a=1 to 40

Set vcountry $(a) = fieldvalue( 'Country' , $(a));

When I'm trying to display labels with above variables it's not showing any data

Like vcountry1 =

Vcountry2 =

So can u suggest me any way that I can label my each and every colomn using loops in scripting

Or is there any wrong in my script .

Thanking u all

Brad

Re: Problem with expression labels

Wed, 25 May 2011 14:08:23 GMT

Hi,

try this syntax. I believe you should use let instead of set:

LOAD * INLINE [
    Country
    SE
    DE
    DK
    FE
];
 
For a=1 to 4
     let vcountry$(a) = fieldvalue( 'Country' , $(a));
next

Good luck,

Jonas

www.optivasys.se

QlikView Consultant

Re: Problem with expression labels

Wed, 25 May 2011 14:49:54 GMT

Hi Jonas

Thanks for your reply

I tried let instead of set but when I'm using let now it's not even showing me the variables vcountry also

Is there any other way to solve this ...

Thanks a lot Jonas

Brad

Re: Problem with expression labels

deepakk — Wed, 25 May 2011 17:05:11 GMT

Hi Brad,

If you want the name as Column then just drag the dimension to top of the expression. It will serve your purpose.

In the attach application I have displayed both ways,

I hope this helps.

Deepak

Re: Problem with expression labels

Thu, 26 May 2011 03:52:42 GMT

Thanks Deepak ,

I know we can do that in a pivot table but my req. is a straight table and i'm trying to write a loop for a runtime variable which stores those values in the specified colomn ...

thanks a lot

Bradd