Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
sum({1<[Source Type]={'RACE_REV_EST'},Quarter=>} NAT_AMT)/$(vScaleM)
sum({1<[Source Type]={'RACE_REV_EST'},Quarter=>} NAT_AMT)/$(vScaleM)
Mwoolf,
This is exactly what I was looking for.
Thanks
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)
"Quarter =" with nothing after it will ignore any selections made on the Quarter field:
=sum({<[Source Type]={'RACE_REV_EST'}, [Quarter] = >} NAT_AMT)/$(vScaleM)
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.
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.