charts and expressions

[prasadreddy]

Hi Community,

I am new to QlikView Technology, i want to know that how to write expressions in different chatrs,

how many dimensions supports to each charts,

example: bar charts, Line charts, combo charts, gauge charts, straight table, Pvot tables,

[alexandros17]

In my experience I've used more than 20 dimensions and t works ...

For expressions  (if the field is Amount)

you can

sum(Amount)

Count(Amount)

and a lot of other things ... expecially with set analysis ... I suggest to read Help

[Gabriel]

Hi,

Expressions are used in charts to define calculated data, e.g. the data shown on the y-axes in a standard bar chart or line chart. Although it is often sufficient to simply click together the most basic chart expressions in the edit expression dialog, QlikView supports far more complex chart expressions, involving functions, fields and operators. However, please note that a few differences exist between script expression and chart expressions in terms of syntax and available functions.

can I just add to point above, that expression in QlikView is similar to Formula in excel. If you are coming from excel background this will make more sense.

A simple expression would be sum(sales), count(salesperson).......there are more and complex expression.

Regards,

Gabriel

[prasadreddy]

Thanks for reply,

Could you please give me two or more complex expressions examples for combo chart and bar chart and guage chart....

[Gabriel]

Hi,

You can have

1- AGGR(sum(Sales)/Count(Order),Country,Salesperson)  = Average Order Value for the salespeople within each country.

2- MAX(Aggr(sum(Sales)/ count(Order),Country, Salesperson)) =This will return largest sales for salesperson in the country)

3- Min(aggr(max(value),customer)) = Minimum value ofthe max value by customer.

Hope this is helpful. Kindly mark previous explanation and this wwith correct QlikView scores for answer to question.

Regards,

Gabriel

[Gabriel]

Hi

Can you mark me as rightly answer your question please. Thanks

Regards,

Gabriel