i have data like Employee sales amount by Product.
i want to create rank column(Expression) based on the Total amount .
How to achieve this.
Iam using JS Pivot extension but not allowing me to write Second Expression.
hhhhhhh P1 5000 1
djsdjcsjd P2 4000 2
please find the Excel data,Qvf application file
Solved! Go to Solution.
client requirement was to show Totals at Right side .But In Qlik sense Totals showing in Starting(Left Side).
and more over i want to show total employee wise in right side but default Pivot table showing Total based on the Product wise.
Please check the attachment. the pivot table below is created with normal pivot table provided with Qliksense. May be with tidying it bit more can get you to your result. Hope It helps.
Hi Shiva almost done .
1)i want to sort by Rank,
2)i want to show Amount in Dollars
How to achieve this