topic Re: Re: How to display datas conditionned by datas in another column? in QlikView

How to display datas conditionned by datas in another column?

Thu, 20 Mar 2014 08:44:13 GMT

I am working with a file such as follows:

Mnemonic	Maturity_Two	STD_Two	Maturity_One	STD_One
FJWSH489	30Y	204269,469	5Y	206833,719
KMYUC667	5Y	274532,891	5Y	277955,472
PJMCM574	3Y	177099,96	1Y	177275,884
HKHGV576	30Y	47370,9541	5Y	47964,9703
MHYLG715	30Y	372818,911	5Y	377506,833

I want to display a chart summing STD_One and STD_Two if Maturity_One= Maturity_Two

Thanks a lot,
Thibaud

Re: How to display datas conditionned by datas in another column?

jonathandienst — Thu, 20 Mar 2014 08:55:46 GMT

=Sum(If(Maturity_One = Maturity_Two, STD_One))

=Sum(If(Maturity_One = Maturity_Two, STD_Two))

HTH

Jonathan

Re: How to display datas conditionned by datas in another column?

PrashantSangle — Thu, 20 Mar 2014 08:58:55 GMT

Hi,

Please find attach document

regards,

Re: How to display datas conditionned by datas in another column?

Anonymous — Thu, 20 Mar 2014 09:02:29 GMT

use the below expression

=if(Maturity_Two=Maturity_One,Sum(STD_One)+sum(STD_Two))

Please find attachement

anant

Re: How to display datas conditionned by datas in another column?

Thu, 20 Mar 2014 10:40:27 GMT

The fact is they are NEVER equals in the same line, so if I use your solutions if displays: "no data".

Maturity_One and Maturity_Two are both buckets calculated using a barycentric projection.

Here are the two charts I want to be in one:

Re: How to display datas conditionned by datas in another column?

PrashantSangle — Thu, 20 Mar 2014 11:48:16 GMT

Hi,

can you post sample data,

Regards,

Re: How to display datas conditionned by datas in another column?

Thu, 20 Mar 2014 12:12:08 GMT

Hi,

Check the atatched app.

Regards

Kumar

Re: How to display datas conditionned by datas in another column?

Mon, 24 Mar 2014 12:57:00 GMT

Hi,
I'm a student and using a Personal Edition, could you please display your information in a form I can read?

Thank you in advance
Regards,
Thibaud

Re: Re: How to display datas conditionned by datas in another column?

Tue, 25 Mar 2014 04:30:21 GMT

Hi,

Like this

Test:

Load * Inline [
Mnemonic, Maturity_Two, STD_Two, Maturity_One, STD_One
FJWSH489, 30Y, 204269469, 5Y, 206833,719
KMYUC667, 5Y, 274532891, 5Y, 277955,472
PJMCM574, 3Y, 17709996, 1Y, 177275,884
HKHGV576, 30Y, 473709541, 5Y, 47964,9703
MHYLG715, 30Y, 372818911, 5Y, 377506,833
];

Test1:
Load Mnemonic,Maturity_Two AS Maturity,STD_Two as STD
Resident Test;

Load Mnemonic,Maturity_One AS Maturity,STD_One as STD
Resident Test;

Drop Table Test;

and this could be the chart

Re: Re: How to display datas conditionned by datas in another column?

Tue, 25 Mar 2014 08:51:21 GMT

That works, thank you so much!