Pivot Table...

[#1]

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

[vikasmahajan]

-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

[Digvijay_Singh]

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).

[Anonymous]

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