Solved: Data modeling - Qlik Community

Report Inappropriate Content · ‎2016-08-02

Hi ,

i have two sources to craete a report,

in first source i have YieldCurve,tenor,Nett fields.

in second source i have YieldCurve,shock,tenor in days,Scenarios.

in the second table we have 250 scenarios for each Yieldcurve.

so, what i have to show in the report is YieldCurve,Scenarios(1-250),shock,shock*Nett

how can i get this? if any one knows pls help me.

i used applymap and left join both are not working.

thanks.

Report Inappropriate Content · ‎2016-08-02

First table..

second:

i want o/p like this..

ramasaisaksoft · ‎2016-08-02

Hi Soumya,

1)Apply map will help to you ,

2)just alias the name in First table tenor as ...tenor

so there is no Syn keys and you can proceed without doing any thing.

if not can you share the code which you written in the script?So that we will help to you.

For this Pivot table is better to UI,

Report Inappropriate Content · ‎2016-08-02

Hi Thank you for reply.

tried alredy..

i have a common field YieldCurve,

ApplyMap('scenarios',YieldCurve,'') as [Scenario Number],

but i am getting only senario 1 remaining 249 scenarios not getting

ramasaisaksoft · ‎2016-08-02

can you share any sample data?

and also sample expected output

Report Inappropriate Content · ‎2016-08-02

ApplyMap('scenarios',YieldCurve,'') as [Scenario Number],

by using this i am not getting any output getting blank.

what i have done is created a table(temp) with 250 Scenarios and i used applymap with the temp table,

now i am getting only one scenario

Report Inappropriate Content · ‎2016-08-02

First table..

second:

i want o/p like this..

Data modeling