Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Question

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





1 Solution

Accepted Solutions
Not applicable

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]))'}>...


View solution in original post

6 Replies
Creator III
Creator III

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.

Not applicable

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]))'}>...


View solution in original post

Not applicable

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

Not applicable

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

Not applicable

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.

Not applicable

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