topic Re: Data Linking in QlikView

Data Linking

Wed, 06 Nov 2013 09:34:28 GMT

Hi All,

I have 2 data files Actual, Given.

Actual data file contains Project Num, PName, Pool,Manager, November, December, January fields. Here November, december, january fields contains month wise Demand data

Given Data file contains Project Num, PName, Pool, Manager, Month, Demand Actual, Demand Given. Here Month contains November, December, January as field values.

I want to show by default the data for November, December and January should be as follows

I want to create one List box which contains Months November, December and January. If i click on January then only january should be shown, If i click on November then only November data should be shown.

This is an urgent requirement, Please Anybody take a look and give me solution.

I'm attaching sample data files also, Please provide me solution

Re: Data Linking

lironbaram — Wed, 06 Nov 2013 10:18:05 GMT

hi have a look at the attach file

all that was needed is to cross table to actual data in the load script

Re: Data Linking

Gysbert_Wassenaar — Wed, 06 Nov 2013 10:18:39 GMT

You can use the crosstable function to transform the Actual data. See attached qvw

Re: Data Linking

Wed, 06 Nov 2013 11:06:42 GMT

Hi Bra'am,

Thanks for reply, i met my req with your suggestion.

Thanks,

M V

Re: Re: Data Linking

Wed, 06 Nov 2013 11:43:46 GMT

Hi Wassenaar,

Sorry for troubling you, One more req is added here

I have another file Inc Data which contains Project Number, PName, Pool, Nov Inc/Dec, Dec Inc/Dec, Jan Inc/Dec fields. Based on the Pool and project number i have to add the values of Nov Inc/Dec, Dec Inc/Dec, Jan Inc/Dec to Demand data

For ex:

In demand data file data is like as follows

in Inc Data file the data is like as follows

It should add to Demand of Demand data file, Then the output will be like as follows

If the value is negative the it should subtract, if value is Possitive then it should add to Demand data and it should reflect on Demand and total (in exapmle 9, 7.1) should show in the table.

Please help me on this

i'm attaching Inc Data file also here.

Thanks,

M V

Re: Re: Re: Data Linking

Gysbert_Wassenaar — Wed, 06 Nov 2013 12:06:55 GMT

Maybe like attached qvw.