Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have done up 2 line charts, where one shows all the currency types and another one showing the line chart for USD.
I want to make sure that the USD line chart remains fixed no matter what currency i choose from my listbox for the other chart.
This is so that I can compare the two currency charts, eg. AUD and USD, MYR and USD etc etc
I tried detaching the USD chart but once I save and exit, the detach property will disappear when I open it up again, which is troublesome.
Is there any way that I can change my in expression for the USD chart to remain fixed?
Below is my expression for the USD chart. I used two dimensions, tenor and date of reporting.
Sum(
{1<Curr_Type={'USD'}>}
Rate_Exp
)
Below is my expression for the charts will currency types.
Sum(Rate_Exp)
I already tried modifying my 1 with $, remove quote ' ' but it still does not work..
Any suggestions?
Hi nursyafiqah,
Its Simple,
Make ur exp like beleow
Sum({$<CUR_TY={"$(=Only({$<CUR_TY={'USD'}>}CUR_TY))"}>}CUR_VAL)
its working!!!
PFA
Thanks
Your expression looks correct. Can you post a sample QVW?
-Rob
Hi nursyafiqah,
Its Simple,
Make ur exp like beleow
Sum({$<CUR_TY={"$(=Only({$<CUR_TY={'USD'}>}CUR_TY))"}>}CUR_VAL)
its working!!!
PFA
Thanks
Hi People of Qlikview,
thanks for your replies.
Parthiban, I modified your example file, and it works thank you. Im trying to fit it in my working file.
Previous problem is that, in my working file, the USD line chart changes too when I select a certain currency. I just wonder why
Hi Parthiban,
my file has two dates, therefore, there should be two lines in the USD chart and 12 lines in the ALL chart.
Is it because of this condition that my charts change accordingly?
No nursyafiqah,
Its should work.
if possible can u please attach ur sample file with ur 2 dates
Hi,
I've attached a sample file. And its absolutely working right.
But my working file is not
I cant disclose the working file as it is confidential.
I've tried imitating the sample file as closely as possible but it still could not work..