topic Re: Budget vs Actual in QlikView

Budget vs Actual

Mon, 30 Mar 2015 12:32:58 GMT

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

Re: Budget vs Actual

avinashelite — Mon, 30 Mar 2015 12:51:30 GMT

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

Re: Budget vs Actual

avinashelite — Mon, 30 Mar 2015 12:52:44 GMT

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