topic Re: Add a value on a dimension in a bar chart. in QlikView

Add a value on a dimension in a bar chart.

Thu, 24 May 2012 07:06:40 GMT

Hi,

I want to add a value on my dimension in a bar chart, not in the script.

For exemple : I want add 1 country on my dimension so i try :

=ValueList('Miami',DimCountry)

but that doesn,'t work.

How have to I make ?

Thanks.

Add a value on a dimension in a bar chart.

Jason_Michaelides — Thu, 24 May 2012 07:28:55 GMT

Hi,

ValueList() is very picky about what it receives. You need to create a variable, vCountry and set it to (with the equals sign):

='ValueList(' & Chr(39) & 'Miami,' & Chr(39) & Concat(Distinct DimCountry,Chr(39) & ',' & Chr(39)) & ',)'

Then, in the dimension use =$(vCountry)

Hope this helps,

Jason

Add a value on a dimension in a bar chart.

Jason_Michaelides — Thu, 24 May 2012 07:29:57 GMT

Note: 'amp' was added by my phone when posting this! Ignore them!

Add a value on a dimension in a bar chart.

Thu, 24 May 2012 10:32:33 GMT

thanks for your help but that doesn't work...

other idea ?

thanks.

Add a value on a dimension in a bar chart.

Jason_Michaelides — Thu, 24 May 2012 11:50:43 GMT

I was on a train when I wrote that and got the syntax wrong! Sorry...try:

='ValueList(' & Chr(39) & Concat(DISTINCT DimCountry,Chr(39)&Chr(44)&Chr(39)) & Chr(39) & ',' & Chr(39) & 'Miami' & Chr(39) & ')'

Jason

Add a value on a dimension in a bar chart.

Thu, 24 May 2012 13:19:35 GMT

Jason, your soluce are true in an object text but not in a dimension

there are not a solution more simple ?

kind : DimCountry + 'Miami'

Add a value on a dimension in a bar chart.

Jason_Michaelides — Thu, 24 May 2012 13:24:17 GMT

I have used this successfully in a dimension. If you can post a sample of your app I can take a look.

Re: Add a value on a dimension in a bar chart.

Thu, 24 May 2012 13:34:39 GMT

for example :

Thanks.

Re: Add a value on a dimension in a bar chart.

Jason_Michaelides — Thu, 24 May 2012 14:53:17 GMT

You didn't create a variable as I suggested. you also need to alter the expression to reference the ValueList().

See attached.

Re: Add a value on a dimension in a bar chart.

Thu, 24 May 2012 15:24:45 GMT

Yes i try this but I don't arrive to write this in the script

Thanks a lot you are my rescuer

Re: Add a value on a dimension in a bar chart.

Thu, 24 May 2012 15:56:56 GMT

I suggest you to create a separate dimension, and use it as the dimension of your table.

Your data :

Data:
load * Inline
[DimCountry, Sales
'New York',1000
'Paris',2000
'Sidney',3000
];

You create a new separated dimension:

FullCountry:
LOAD DISTINCT DimCountry AS FullCountry,
1 AS OriginalCountry
RESIDENT Data;
CONCATENATE (FullCountry)
LOAD * INLINE [
FullCountry, OriginalCountry
Miami, 0
];

I add a flag "OriginalCountry" to know easylly if I deal with a country that comes from the original list, or not.

In my expression, I can make the difference between the country flagged as "original":

if(OriginalCountry = 1,
sum(if (FullCountry = DimCountry, Sales)),
'This is another country'
)

(see attached file)

Note that in your calculated dimension for the exemple given with the "concat" and "valuelist", you forgot to suround your expression with a "$(=" and a ")", to ask QV to evaluate the string you created.

But putting it in a variable is far more tidy

Re: Add a value on a dimension in a bar chart.

Thu, 24 May 2012 16:01:14 GMT

Yes its a good idea, thanks a lot