topic Re: Qlik Sense Rank Calculation in Pivot table in App Development

Qlik Sense Rank Calculation in Pivot table

joshibabu_are — Mon, 27 Mar 2017 13:06:32 GMT

Hi Guru's,

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.

Example Output

EmployeeName

Product

Total Rank

hhhhhhh P1 5000 1

djsdjcsjd P2 4000 2

........

Thanks,

Joshi

please find the Excel data,Qvf application file

Re: Qlik Sense Rank Calculation in Pivot table

Anonymous — Mon, 27 Mar 2017 13:15:23 GMT

Is there any specific functionality that made you opted for JS Pivot rather than one provided by default??

Re: Qlik Sense Rank Calculation in Pivot table

joshibabu_are — Mon, 27 Mar 2017 13:22:59 GMT

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.

Thanks,

Joshi

Re: Qlik Sense Rank Calculation in Pivot table

Anonymous — Mon, 27 Mar 2017 13:39:55 GMT

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.

Re: Qlik Sense Rank Calculation in Pivot table

joshibabu_are — Mon, 27 Mar 2017 14:11:49 GMT

Hi Shiva,

thanks for your time.trying ur solution in my report.

How to move Rank Column to last in Pivot table.

Thanks,

Joshi

Re: Qlik Sense Rank Calculation in Pivot table

Anonymous — Mon, 27 Mar 2017 14:15:08 GMT

Clik on Sort, for the dimension with Pick() uncheck the auto sorting, and select by expression and give "Dim" in the expression.

Re: Qlik Sense Rank Calculation in Pivot table

joshibabu_are — Mon, 27 Mar 2017 14:30:35 GMT

Hi Shiva almost done .

1)i want to sort by Rank,

Example:1,2,3,,,,,,,25

2)i want to show Amount in Dollars

How to achieve this

Thanks,

Joshi

Re: Qlik Sense Rank Calculation in Pivot table

Anonymous — Mon, 27 Mar 2017 14:53:30 GMT

Please find attachment

Re: Qlik Sense Rank Calculation in Pivot table

Peter_Cammaert — Mon, 27 Mar 2017 15:11:38 GMT

Can you please move your discussion to an appropriate Qlik Sense forum?

See QlikCommunity Tip: How to move your discussion thread

Thanks.