topic Data modeling in QlikView

Data modeling

Wed, 25 Nov 2020 16:16:04 GMT

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.

ramasaisaksoft — Tue, 02 Aug 2016 10:04:49 GMT

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,

Tue, 02 Aug 2016 10:09:21 GMT

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 — Tue, 02 Aug 2016 10:14:34 GMT

can you share any sample data?

and also sample expected output

Tue, 02 Aug 2016 10:18:32 GMT

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

Tue, 02 Aug 2016 10:33:52 GMT

First table..

second:

i want o/p like this..