topic Re: Separated line charts for one selection in QlikView

Separated line charts for one selection

Thu, 18 Jul 2013 04:18:21 GMT

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?

Re: Separated line charts for one selection

rwunderlich — Thu, 18 Jul 2013 04:38:22 GMT

Your expression looks correct. Can you post a sample QVW?

-Rob

Re: Separated line charts for one selection

parthiband — Thu, 18 Jul 2013 05:10:43 GMT

Hi nursyafiqah,

Its Simple,

Make ur exp like beleow

Sum({$<CUR_TY={"$(=Only({$<CUR_TY={'USD'}>}CUR_TY))"}>}CUR_VAL)

its working!!!

PFA

Thanks

Re: Separated line charts for one selection

Thu, 18 Jul 2013 05:28:39 GMT

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

Re: Separated line charts for one selection

Thu, 18 Jul 2013 05:35:32 GMT

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?

Re: Separated line charts for one selection

parthiband — Thu, 18 Jul 2013 05:58:21 GMT

No nursyafiqah,

Its should work.

if possible can u please attach ur sample file with ur 2 dates

Re: Separated line charts for one selection

Thu, 18 Jul 2013 06:18:54 GMT

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..