Discussion Board for collaboration related to QlikView App Development.
I have small doubt.
For example i hve top 10 sales 100 for product "A"
and same for top 10 sales 100 for product"B"
i want to get top 10 sales ?
what will be the result?
not dimension limit.
For example:in same product i hve two top 10 values? which will give the result
You have two products only.....product A,B
YOU CON'T FIND TOP 10 FOR 2 PRODUCTS
If You Have More then 10 products then only you can find top ten products......
Please look into my data and qvw
in excel sheet 3data
What is the expected output?
What do you want to achieve here?
in my data
i hve emp id 2 and yearsalry is 63000 for both is hvng two records so.. wen i use dimen lim top 5
how it is caluclates?
Please find the below screenshot for using rank function
use if condition for top 5 or 10 values.
that is okay. in abve ur screen sht
sales coordinator sum(yearsalary) 65000
if i hve same sales coordinator sum(yearsalary) 65000