Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Typical data visualization on a dashboard using calculations

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

4 Replies
Mark_Little
Luminary
Luminary

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

Not applicable
Author

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

settu_periasamy
Master III
Master III

Hi,

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

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

Not applicable
Author

thanks for your supports ..