topic Re: Creating a static Chart in QlikView

Creating a static Chart

Tue, 04 Sep 2012 16:59:44 GMT

Hi,

I created a chart to show revenue year to date by week. Now I'm trying to make this chart static so regardless of the selection on the page it shows the same information. The expression is below. I've tried to put a 1 or $ in front of the entire expression but qlikview doesn't like it. Please let me know if you can help.

sum

( {<[Source Type]={'RACE_REV_EST'},Quarter = >} NAT_AMT) / $(vScaleM)

Re: Creating a static Chart

m_woolf — Tue, 04 Sep 2012 17:11:35 GMT

sum({1<[Source Type]={'RACE_REV_EST'},Quarter=>} NAT_AMT)/$(vScaleM)

Re: Creating a static Chart

Tue, 04 Sep 2012 17:14:46 GMT

Mwoolf,

This is exactly what I was looking for.

Thanks

Re: Creating a static Chart

Tue, 04 Sep 2012 19:43:00 GMT

I'm now trying to write the same expression but only freeze the quarter portion. I've tried the below expression but it isn't working. Where am I going wrong?

sum

({<[Source Type]={'RACE_REV_EST'}, ({1<[Quarter] = {'Q1'}+{'Q2'}+{'Q3'}+{'Q4'}>})>} NAT_AMT)/

$(vScaleM)

Re: Creating a static Chart

Nicole-Smith — Tue, 04 Sep 2012 19:49:13 GMT

"Quarter =" with nothing after it will ignore any selections made on the Quarter field:

=sum({<[Source Type]={'RACE_REV_EST'}, [Quarter] = >} NAT_AMT)/$(vScaleM)

Re: Creating a static Chart

Tue, 04 Sep 2012 19:54:57 GMT

That will still allow the graph to shift if a specific quarter is selected. I want to show all quarters on the graph regardless of current selections.

Re: Creating a static Chart

Nicole-Smith — Tue, 04 Sep 2012 20:00:05 GMT

With the expression I have posted above, the graph will not change if a specific quarter is selected. It will always show all quarters.

See attached for an example.

If you can't view the example, you can make it on your own.

The load script is:

Table:
LOAD * INLINE [
Quarter, Sales
Q1, 1000
Q2, 2000
Q3, 3000
Q4, 4000
];

I have a list box with the Quarter field.

And I have a straight table with:

Dimension:

Quarter

Expression:

sum({<Quarter>}Sales)

When you select any of the quarters in the list box, the straight table stays the same. If there were other fields, they would still affect the data.