topic Re: Pivot Table... in QlikView

Pivot Table...

Mon, 29 Feb 2016 05:49:02 GMT

Hi friends, I have a question:

I have a pivot table with 4 fields: Country, Code, Person, Sales.

I want to get a new table with records of the above pivot table that sales is greater than 10000$.

I need to report new table by Email or PDF file.

TNX

Re: Pivot Table...

vikasmahajan — Tue, 01 Mar 2016 07:01:36 GMT

-Create Pivot table with required fields with following expression

=sum({<Item = {“=rank(sum(Sales),4)>=1000”}>} Sales)

use following Qvw to send email.

HTH

vikas

Re: Pivot Table...

Digvijay_Singh — Tue, 01 Mar 2016 07:32:56 GMT

You can clone/copy this pivot table object, and then on new pivot table you can apply fast type change by selecting Pivot table and straight table, its available in general tab. So ultimately you got new table out of your pivot table.

Then change the sales expression as Sum({<Sales={">=1000"}>} Sales).

Re: Pivot Table...

Anonymous — Tue, 01 Mar 2016 07:50:57 GMT

Divide your requirement into two parts:

First create another table with expression like?

=sum({<SalesField={'>10000'}>} SalesField)

Now use Macro to send this new report as a mail to Users which is mentioned step by step in followed threads?

Useful Qlikview Macros

Automated Excel Export and Email Macro

EXPORTING OBJECTS AND SENDING EMAIL IN QLIKVIEW | Smart ERP Solutions