topic Re: Typical data visualization on a dashboard using calculations in QlikView

Typical data visualization on a dashboard using calculations

Wed, 11 Nov 2015 06:04:46 GMT

Hi friends,

i am very new to qlikveiw, and iam not aware on below things,i need to use expressions for below mentioned things,kindly send me the usefull example with formula.

->Sales

total $XX

target $xx

variance $xxx

-->Expense

total $xx

target $xxx

variance $xx

->inventory

total $xxx

target $xxx

variance $xxx

Thank you

Re: Typical data visualization on a dashboard using calculations

Mark_Little — Wed, 11 Nov 2015 09:00:55 GMT

Hi,

Could you possible supply some sample data as it really depends on how it is loaded into the dashboard.

It could be as simple as SUM(Sales) for the sales total if the sales value is stored in a field called sales

or SUM({<TransactionType={'Sales'}Value>}) if all the details are stored in one transactions table and broken down by the TransactionType field.

Mark

Re: Typical data visualization on a dashboard using calculations

Wed, 11 Nov 2015 13:28:01 GMT

Thanks for your reply friend,,i will provide the data which i have..

Re: Typical data visualization on a dashboard using calculations

settu_periasamy — Wed, 11 Nov 2015 14:25:52 GMT

Hi,

Hope you know, some example document available when you installed qlikview..

the path is C:\Program Files\QlikView\Examples\Documents

Re: Typical data visualization on a dashboard using calculations

Thu, 12 Nov 2015 05:55:13 GMT

thanks for your supports ..