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

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
Author

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

View solution in original post

9 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
PrashantSangle

Hi,

Please find attach document

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

use the below expression

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

Please find attachement

anant

Not applicable
Author

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

PrashantSangle

Hi,

can you post sample data,

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi,

Check the atatched app.

Regards

Kumar

Not applicable
Author

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
Author

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
Author

That works, thank you so much!