topic Re: Use a variable as dimension in QlikView

Use a variable as dimension

jubarrosor — Tue, 09 Sep 2014 17:03:37 GMT

Hello,

I'm trying to create a bubble chart.

I need to use an expression as dimension and I created a variable for it. QV says that there is an error but my expression it's good because I'm using it in other charts:

The expression is:

mFinishedWithoutDelay =

count( {$<[Status] = P({1<[group]={'FINISHED'}>}[Description]),

[delay_id]={'1'}>} DISTINCT request_id )

and the error is:

Error: Garbage after expression: "FINISHED"

What is the problem?

Thank you and sorry for my english.

Best regards!.

Re: Use a variable as dimension

Gysbert_Wassenaar — Tue, 09 Sep 2014 17:29:13 GMT

That expression will return only one value if you don't aggregate over dimensions. So it does not make sense to use it as a calculated dimension. How are you using it anyway: =mFinishedWithoutDelay or =$(mFinishedWithoutDelay) ?

Re: Use a variable as dimension

jubarrosor — Tue, 09 Sep 2014 20:17:11 GMT

Hi Gysbert Wassenaar,

it's not the only dimension that i'm using (I'm using other twice)

I'm using =$(mFinishedWithoutDelay)

Thank you!

Re: Use a variable as dimension

Gysbert_Wassenaar — Wed, 10 Sep 2014 07:53:03 GMT

Can you post an example document that demonstrates the problem?

Re: Use a variable as dimension

tresB — Wed, 10 Sep 2014 09:23:52 GMT

If by any chance, you are using single quotes while defining variable, like:

mFinishedWithoutDelay = '<Your expression>'

Then, you might try with double quotes within set analysis like:

='count( {$<[Status] = P({1<[group]={"FINISHED"}>}[Description]),

[delay_id]={1}>} DISTINCT request_id )'

Re: Use a variable as dimension

jubarrosor — Wed, 10 Sep 2014 12:52:06 GMT

Hi,

finally I resolved the problem using aggr.

I've used the expression aggr($(mFinishedWithoutDelay), Office)

Thank you very much!

Best Regards!