Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Budget vs Actual

Dears,

i am a new in qlikview and i build the all sales dashboards and my manager ask me to add new dashboards that contain the (Budget & Actual) comparative and he needed by using bar charts ;so the issue is i have the years and i don't have the month what i have is a (periods(12 period (12 column))) and the data type for this columns is money , how can i use this 12 period as a month (Jan, Feb.....)

as what i know the bar chart need 1 Megars & 1 or to diminutions  ; i try to use Variables for each period and do Sum for this period and store it in each variable but i know it is not the solution ,

if any one have an idea pleeeeeeeeeeeease   tell me .......

and this is a sample from my data

2 Replies
avinashelite

Hi Ahmad,

Try to convert your 12 period column into row values

i.e eg

period1,perios2,...

10,20

30,60

to something like

period,value

period1,10

period2,20

period1,30

period2,60

so that you can use this period as the dimension in the charts.

to convert the columns into row use the

crosstable() function

avinashelite

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field name is the field to contain the attribute values.

data field name is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.

Examples:

Crosstable (Month, Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Hope this helps you