what is difference between dimension and expression in qlikview ?

[#1]

what is difference between dimension and expression in qlikview ?

[SunilChauhan · Accepted solution]

dimesion can be field  but expression could be sum(field),count(field) .you could calculate some amount .count some id

i mean you could apply functions in expression where in dimesion you could take direct fields

E:

i want to display sum of sales country wise

then in  dimesion i will take Country

and in expression i will write sum(sales)

hope this helps

[avinashelite]

Hi Manoj,

To explain it in simple words:

Dimension acts as base data in the charts, on which all the calculation will get calculated.

Expression always works above the Dimension what you have used.

Eg.

Dimension

A

B

Expression sum(amount)......

in this case all the amount gets calculated on the dimension A and B.

Hope this helps u!!

[#4]

Dimension is the set of values for the chart to iterate over when it calculates the values for its expression.

for eg. Year is dimension

and Expression which calculate values for dimension

for eg. Sales is expression

now the chart for above dimension and expression will show sales for Year.

Year     Sales

2009     150

2008     140

2010     147

the difference between them is

expression can be aggregated but dimension is not.

dimension can be grouped by Drill down but expression is not.

[SunilChauhan]

Hi Bhawna,

we can also aggregate dimesions

for example

aggr(Max(date),EMPID)

[#6]

Dimension - A dimension table is a table in a star schema of a data warehouse. A dimension table stores attributes, or dimensions, that describe the objects in a fact table.

Expression- Expression is data script which is written to execute the function/formula.

Example:  " =Sum(Sales) " , "= Avg(Sales)"

[#7]

thank you

[sujeetsingh]

Just study

"data warehouse concepts by ralph kimball"

[#9]

thnX chauhan u gave me a simple example ..,nice i understand 

[SunilChauhan]

take a qvw  and load

Load * inline [

Country,Sales

India,100

US,200

Japan,300

];

take Country in dimension and sum(sales) in expression