topic Re: Data BAse Format in QV in QlikView

Data BAse Format in QV

abhaysingh — Thu, 26 Feb 2015 13:00:42 GMT

business	jan 14	feb 14	March 14	Apr 14
target	10	20	30	40
actual value	8	18	28	38

i have a data source in this format for different different business but i need this data in below format

Business	month	target	actual value
xyz	jan 14	10	8
xyz	feb 14	20	18

is this possible in QV after doing transformation becasue i have so many data in excel format would not possible to define it manually in excel.. kindly suggest

thanks in advance

Re: Data BAse Format in QV

anbu1984 — Thu, 26 Feb 2015 13:13:22 GMT

How do you calculate Mar and Apr target?

Mar = Jan + Feb ?

Apr = Jan + Mar ?

Re: Data BAse Format in QV

abhaysingh — Thu, 26 Feb 2015 13:16:15 GMT

no anbu...i am getting in the similar fashion for rest of the month are these are fixed value

Re: Data BAse Format in QV

buzzy996 — Thu, 26 Feb 2015 13:20:42 GMT

u simply load ur data into pivot table and try to ply with rows & cloumns by moving top to left and left rows a top columns

Re: Data BAse Format in QV

anbu1984 — Thu, 26 Feb 2015 13:23:12 GMT

Check Crosstable

Re: Data BAse Format in QV

abhaysingh — Thu, 26 Feb 2015 13:30:01 GMT

how can i do it with cross table pls give me some examples or process to do it

Re: Data BAse Format in QV

anbu1984 — Thu, 26 Feb 2015 13:36:48 GMT

Initial:

CrossTable(Month,Value)

Load * Inline [

Business,Jan14,Feb14,Mar14,Apr14

actual,8,18,28,38

target,10,20,30,40 ];

Final:

Load Month,Value As Actual Resident Initial Where Business = 'actual';

Join(Final)

Load Month,Value As Target Resident Initial Where Business = 'target';

Drop Table Initial;