topic Field value as Expression in QlikView

Field value as Expression

Mon, 11 Jan 2010 09:00:53 GMT

Hi all, this is my first post here. I'm normally able to easily find the solution I'm looking for just by searching the forum but not today. I've come accross a problem which would best be solved if I were able to force Qlikview to assess the value held in a field as an expression. Now I've found if I use the following:

$(=Expression)

Where Expression is the field containing the expressions. This works when either there is only a single value in the table or I have selected a single value, but when there are multiple expressions defined in the table it frustratingly doesn't seem to work.

Does anyone out there have a trick up their sleeve to help me? Thanks in advance for any suggestions!

Field value as Expression

Miguel_Angel_Baeyens — Mon, 11 Jan 2010 09:42:11 GMT

Hello,

You can use

$(=GetFieldSelections(Expression, Chr(34) & ',' & Chr(34)))

Chr(34) is ASCII code for doble quotes. The idea is not mine, but NMiller's. I've got this one as favourite.

Hope this helps!

Field value as Expression

Mon, 11 Jan 2010 09:55:26 GMT

Hi Miguel,

I gave it a go but it doesn't appear to work, is that solution reliant on some specific setup in the data?

Field value as Expression

Miguel_Angel_Baeyens — Mon, 11 Jan 2010 10:02:15 GMT

I'm using that in some set analysis expressions, that need to separate values by double quotes. You can try without them if your chart or expression doesn't need them.

Field value as Expression

Mon, 11 Jan 2010 10:45:18 GMT

This is very strange for the life of me I cannot get GetFieldSelections() to return anything...

Field value as Expression

Miguel_Angel_Baeyens — Mon, 11 Jan 2010 11:03:49 GMT

Try a simple textbox with

=GetCurrentSelections(yourDateFieldHere or yourCityCodeHere)

and do some selections to see how it changes, if any.

Field value as Expression

Mon, 11 Jan 2010 12:00:47 GMT

That seems to work fine but GetFieldSelections still doesn't seem to want to work 😞

I have attached (hopefully) an example the should be able to better demonstrate what i'm trying to accomplish...
I could do it with a large if statement but given the number of expressions this would just be a pain.

Field value as Expression

prieper — Mon, 11 Jan 2010 14:32:33 GMT

the attached should do it, Miguel has pointed you already the right way

Peter