Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Revenue and Budget data

Hi , I have a requirement to display actuals and budget for all months in a selected year, in which i have always one value selected in Year and Month fields.

Example:

if March is selected, Jan , Feb & Mar should display actuals whereas Apr to Dec should display budget numbers. Can anyone pls help on this?

Revenue:

ClientJanFebMarAprMayJunJulAug
A1009035012512389500123
B20085590255234350250321
C23134512321567120125432
D12312039592332050143

Budget: 

ClientJanFebMarAprMayJunJulAugSepOctNovDec
A12389250120900350125111888999140180
B244325020085345120222777100150190
C56712012523134512321333666120160200
D23320501231203959444555130170210

My output should be Jan to Aug that should be Revenue Table, and remaining Sep to Dec should be Budget table.

Thanks in Advance...

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Raju,

See Attachment

TableA:
CrossTable(Month,Revenue)
LOAD * Inline [
Client Jan Feb Mar Apr May Jun Jul Aug
A 100 90 350 125 123 89 500 123
B 200 85 590 255 234 350 250 321
C 231 345 12 321 567 120 125 432
D 123 120 39 59 23 320 50 143
]
(delimiter is spaces);
TableB:
CrossTable(Month,Budget)
LOAD * Inline [
Client Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A 123 89 250 120 900 350 125 111 888 999 140 180
B 24 43 250 200 85 345 120 222 777 100 150 190
C 567 120 125 231 345 12 321 333 666 120 160 200
D 23 320 50 123 120 39 59 444 555 130 170 210
]
(delimiter is spaces);
LOAD *,Month(Date#(Month,'MMM')) as Month1;
Join (TableA) LOAD * Resident TableB;
Drop Table
TableB;

Regards,

Antonio

View solution in original post

1 Reply
antoniotiman
Master III
Master III

Hi Raju,

See Attachment

TableA:
CrossTable(Month,Revenue)
LOAD * Inline [
Client Jan Feb Mar Apr May Jun Jul Aug
A 100 90 350 125 123 89 500 123
B 200 85 590 255 234 350 250 321
C 231 345 12 321 567 120 125 432
D 123 120 39 59 23 320 50 143
]
(delimiter is spaces);
TableB:
CrossTable(Month,Budget)
LOAD * Inline [
Client Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A 123 89 250 120 900 350 125 111 888 999 140 180
B 24 43 250 200 85 345 120 222 777 100 150 190
C 567 120 125 231 345 12 321 333 666 120 160 200
D 23 320 50 123 120 39 59 444 555 130 170 210
]
(delimiter is spaces);
LOAD *,Month(Date#(Month,'MMM')) as Month1;
Join (TableA) LOAD * Resident TableB;
Drop Table
TableB;

Regards,

Antonio

View solution in original post