Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Separated line charts for one selection

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?

1 Solution

Accepted Solutions
parthiband
Partner - Creator
Partner - Creator

Hi nursyafiqah,

Its Simple,

Make ur exp like beleow

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

its working!!!

PFA

Thanks

View solution in original post

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

parthiband
Partner - Creator
Partner - Creator

Hi nursyafiqah,

Its Simple,

Make ur exp like beleow

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

its working!!!

PFA

Thanks

Not applicable
Author

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

Not applicable
Author

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?

parthiband
Partner - Creator
Partner - Creator

No nursyafiqah,

Its should work.

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

Not applicable
Author

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