String Value in expression ?

[#1]

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,

[rajeshvaswani77]

Hi,

It seems, [MyStringValue] itself has Null.

thanks,

Rajesh Vaswani

[MarcoWedel]

what is [MyStringValue]?

field?

variable?

string constant? Did you use single quotes?

regards

Marco

[#4]

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)]

[IAMDV]

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,

DV

www.QlikShare.com

[#6]

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,

[#7]

Here two picture for more understanding :

[hic]

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

[IAMDV]

Just adding to what HIC mentioned above.

Here is the video tutorial on FirstSortedValue function.

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

Good luck!

Cheers,

DV