Qlik Community

Qlik Sense Cloud Discussions

ts3st1000
New Contributor

Chart on two variables

I am trying to draw a chart based on two sets of two columns. example below shows the currency and sales per currency (first raw: usd sales = 100, eur sales = 25)

Currency1Currency2Sales1Sales2
USDEUR10025
JPYUSD20050
GBPCHF30075
CHFJPY400100

I am trying to merge all and draw (Sales1 + Sales2) by currency while ignoring all USD sales. ultimately, based on the 4 columns above, i would like to draw this:

CurrencySales1 + Sales2
EUR25
JPY200 + 100
GBP300
CHF300 + 400

Thanks very much for the help.

Regards,

Ra

6 Replies
ts3st1000
New Contributor

Re: Chart on two variables

Any luck on this question .... your help is much appreciated.

Thank you.

robert99
Valued Contributor II

Re: Chart on two variables

Hi

Is CHF 300+400. Or 75+400?

ts3st1000
New Contributor

Re: Chart on two variables

Yes Robert, that should be 75 + 400 for CHF. Thank you for spotting that. Do you have an idea how to draw this chart please ?

simotrab
Contributor II

Re: Chart on two variables

Hi,

is it possible to work on data script or not?

robert99
Valued Contributor II

Re: Chart on two variables

It depends how you have loaded your script

I would MAYBE load as two loads and concatenate. something like

DATA:

Load

'Curr1' as TypeCurr ,

Currency1 as Currency,

Sales1 as Sales

etc

and

DATA1:

CONCATENATE (DATA)

Load

'Curr2' as TypeCurr ,

Currency2 as Currency,

Sales2 as Sales

etc

AND THEN use set analysis to exclude USD {<Currency -= {USD} >}

intergnek
New Contributor III

Re: Chart on two variables

Hello ra ta,

It's very difficult to understand your table that you would like.

can you check it or explain better?