topic Set Analysis Question in QlikView

Set Analysis Question

Wed, 02 Feb 2011 20:19:38 GMT

I have the following in a text box:


=Only([Fiscal Quarter])

This displays:

Second Quarter

In a chart I have:






Sum

( {1
//< [Fiscal Year] = {$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {'Second Quarter'} >
<
[Fiscal Year] = {$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {$(=Only([Fiscal Quarter]))}>
}
Pounds )

If I comment the attempt to use the value selected and use the literal I get results, if I try to use the selected quarter, I get no results.

Your help is appriated,

Rick

Set Analysis Question

Anonymous — Wed, 02 Feb 2011 21:11:18 GMT

It looks fine to me on the surface. One cool trick is to not name (label) the expression. When displayed, it will show what each part of the expression evaluates to. You might have to spread the column to see the entire expression.

Set Analysis Question

Wed, 02 Feb 2011 21:12:25 GMT

There is a difference between your literally defined value and the value returned by the dollar sign expansion, quotes.

Your expression didn't paste well, but here's the important part:

...[Fiscal Quarter]={'$(=Only([Fiscal Quarter]))'}>...

Set Analysis Question

Wed, 02 Feb 2011 21:13:46 GMT

In the label =(Only([Fiscal Period]) displays "Second Quarter" (without quotes)

Set Analysis Question

Wed, 02 Feb 2011 21:13:59 GMT

In the label =(Only([Fiscal Quarter]) displays "Second Quarter" (without quotes)

Set Analysis Question

Wed, 02 Feb 2011 21:17:45 GMT

Here's what you should be looking at:

[Fiscal Quarter] = {'Second Quarter'}

There are your quotes. String values in element sets require quotes. Numeric values do not, which is why your Year field is acceptable.

Set Analysis Question

Wed, 02 Feb 2011 21:17:46 GMT

Thank you, that did it.. those pesky quotes I forgot.