Discussion Board for collaboration on QlikView Layout & Visualizations.
I am working with a file such as follows:
I want to display a chart summing STD_One and STD_Two if Maturity_One= Maturity_Two
Thanks a lot,Thibaud
Go to Solution.
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 STDResident Test;Load Mnemonic,Maturity_One AS Maturity,STD_One as STDResident Test;Drop Table Test;
and this could be the chart
=Sum(If(Maturity_One = Maturity_Two, STD_One))
=Sum(If(Maturity_One = Maturity_Two, STD_Two))
Please find attach document
use the below expression
Please find attachement
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:
can you post sample data,
Check the atatched app.
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 advanceRegards,Thibaud
That works, thank you so much!