topic Re: String Value in expression ? in QlikView

String Value in expression ?

Mon, 05 May 2014 14:26:18 GMT

Hi,

It's possible to use String value in expression ?

I've tried :

=[MyStringValue]
=Capitalize([MyStringValue])
=Text([MyStringValue])
=Chr([MyStringValue])

They all return null...

Thanks in advice,

Re: String Value in expression ?

rajeshvaswani77 — Mon, 05 May 2014 14:29:02 GMT

Hi,

It seems, [MyStringValue] itself has Null.

thanks,

Rajesh Vaswani

Re: String Value in expression ?

MarcoWedel — Mon, 05 May 2014 14:40:10 GMT

what is [MyStringValue]?

field?

variable?

string constant? Did you use single quotes?

regards

Marco

Re: String Value in expression ?

Mon, 05 May 2014 14:50:00 GMT

When I use it in Dimension and not in Expression, I didn't have Null Value.

Maybe there is a way to put a Dimension between 2 expressions like that :

[ID] - [Name] - [MyStringValue] - [AVG(COST)] - [SUM(COST)]

1 - Test - What ever it's just a string value - 36$ - 140$

2 - Bar - Fuuuu - 2$ - 89$

3 - Its - Over - 9000$ - 9000$

Dimension : [ID], [NAME], [MyStringValue]

Expression : [SUM(COST)], [AVG(COST)]

Re: Re: String Value in expression ?

IAMDV — Mon, 05 May 2014 14:56:06 GMT

Easy if you can post the sample QVW. Looks like you're losing granularity of data when you move the field from Dimension to Expression. Please try using in both Expression and Dimension to see if it works.

Thanks,

www.QlikShare.com

Re: String Value in expression ?

Mon, 05 May 2014 15:44:27 GMT

That's strange. When I create a Dimension & a Expression with it, they are both visible and so not null.

But When I delete the dimension, the expression is null.

Why ?

Thanks in advice,

Re: String Value in expression ?

Mon, 05 May 2014 15:49:11 GMT

Here two picture for more understanding :

Re: String Value in expression ?

hic — Mon, 05 May 2014 17:39:39 GMT

It's simply that QlikView needs an aggregation function as expression. Otherwise it doesn't know which of several values to return... So, try Mode() or FirstSortedValue().

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

HIC

Re: Re: String Value in expression ?

IAMDV — Mon, 05 May 2014 19:41:18 GMT

Just adding to what HIC mentioned above.

Here is the video tutorial on FirstSortedValue function.

http://qlikshare.com/tag/firstsortedvalue/

Good luck!

Cheers,

Re: String Value in expression ?

Tue, 06 May 2014 01:43:33 GMT

Re: String Value in expression ?

Tue, 06 May 2014 01:50:09 GMT

sir can you help me in my calendar script i have a difficulties with this, i attach a picture of the script and the output, the problem is as you can see in the picture in year to year comparison there is a 13 unknown data . how can i solve this please help me regarding to this matter .....thankyou

Re: String Value in expression ?

Tue, 06 May 2014 07:19:29 GMT

Hi HIC,

I've already tri to add aggrégation function like Capitalize), Chr() or Text(). With Mode() or FirstSortedValue(), i've the same result : nothing ...

By the way, thank you for your link : it's was interesting.

Re: String Value in expression ?

Tue, 06 May 2014 07:36:32 GMT

That's a strange one :

When I've one single value in, it's okay but i've more than one value, I've got no result.