when I export values to excel from straight table I see additional rows

[#1]

Hi Everyone,

I am trying to export values from pivot table to excel but I end up getting extra rows in my exported excel for example

I have a fields called Project Number and Person_Responsible named Edward who has multiple project numbers,

when I am exporting values from the Pivot Table in qlikview to excel , I see redundant rows in excel like extra project numbers for that person responsible that are not present in the datasource also not present in the pivot table in qlikview

Can someone please provide me some inputs on this, is there a way to resolve this?

Thanks in advance

[#2]

Hi Nag,

Right, I have been changing macro name quite a few times so totally lost track of it,

Thank you for your help

[#3]

Hi Nag,

On the other note, I am planning on creating email alerts when the server goes down , as I am new to the qlikview i am not aware on how do I go about it. Do you have any inputs on this?, I am using qlikview 11,

Appreciate your help

[aveeeeeee7en]

Hi Anusha

Read below posts:

If your Application Reload Fails which you have set through QMC than its Mail Alert is possible, which can trigger to various users as per the email ids entered in the Alerts Box.

Re: Send an email if reloading QVW fails

How to send mail alert when server is down?

Hope that helps you.

Regards

[#5]

xD