topic Re: what is difference between dimension and expression in qlikview ? in QlikView

what is difference between dimension and expression in qlikview ?

Fri, 01 Aug 2014 05:22:13 GMT

what is difference between dimension and expression in qlikview ?

Re: what is difference between dimension and expression in qlikview ?

SunilChauhan — Fri, 01 Aug 2014 05:28:56 GMT

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

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

Re: what is difference between dimension and expression in qlikview ?

avinashelite — Fri, 01 Aug 2014 05:31:00 GMT

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

Expression sum(amount)......

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

Hope this helps u!!

Re: what is difference between dimension and expression in qlikview ?

Fri, 01 Aug 2014 05:34:32 GMT

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.

Re: what is difference between dimension and expression in qlikview ?

SunilChauhan — Fri, 01 Aug 2014 05:38:04 GMT

Hi Bhawna,

we can also aggregate dimesions

for example

aggr(Max(date),EMPID)

Re: what is difference between dimension and expression in qlikview ?

Fri, 01 Aug 2014 05:45:55 GMT

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)"

Re: what is difference between dimension and expression in qlikview ?

Fri, 01 Aug 2014 05:47:01 GMT

thank you

Re: what is difference between dimension and expression in qlikview ?

sujeetsingh — Fri, 01 Aug 2014 06:04:23 GMT

Just study

"data warehouse concepts by ralph kimball"

Re: what is difference between dimension and expression in qlikview ?

Mon, 04 Aug 2014 11:54:05 GMT

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

Re: what is difference between dimension and expression in qlikview ?

SunilChauhan — Tue, 05 Aug 2014 02:45:14 GMT

take a qvw and load

Load * inline [

Country,Sales

India,100

US,200

Japan,300

];

take Country in dimension and sum(sales) in expression

Re: what is difference between dimension and expression in qlikview ?

Tue, 03 Nov 2015 08:22:04 GMT

The differences between dimensions and expressions (aka measures) is well explained in the following post :

https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures

Cheers,

Fred