Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to display datas conditionned by datas in another column?

I am working with a file such as follows:

MnemonicMaturity_TwoSTD_TwoMaturity_OneSTD_One
FJWSH48930Y204269,4695Y206833,719
KMYUC6675Y274532,8915Y277955,472
PJMCM5743Y177099,961Y177275,884
HKHGV57630Y47370,95415Y47964,9703
MHYLG71530Y372818,9115Y377506,833

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

Thanks a lot,
Thibaud

1 Solution

Accepted Solutions
Not applicable

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

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

Snip1.JPG

9 Replies
MVP
MVP

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

Hi

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

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

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

Hi,

Please find attach document

regards,

Regards,
Prashant Sangle
anantmaxx
Contributor III

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

use the below expression

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

Please find attachement

anant

Not applicable

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

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:

Sans titre.png

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

Hi,

can you post sample data,

Regards,

Regards,
Prashant Sangle
Not applicable

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

Hi,

Check the atatched app.

Regards

Kumar

Not applicable

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

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

Not applicable

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

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

Snip1.JPG

Not applicable

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

That works, thank you so much!

Community Browser