Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks for your reply friend,,i will provide the data which i have..
Hi,
Hope you know, some example document available when you installed qlikview..
the path is C:\Program Files\QlikView\Examples\Documents
thanks for your supports ..