topic Re: when send to excel,total not displayed when filter is applied in QlikView

when send to excel,total not displayed when filter is applied

prasadcm — Mon, 04 Jul 2016 07:04:22 GMT

Hi,

When we click on 'send to excel' and apply filter to excel...total is not displayed

What should be done to display total?

Regards,

Prasad

Re: when send to excel,total not displayed when filter is applied

MindaugasBacius — Mon, 04 Jul 2016 07:07:07 GMT

The filter should be used on the Total line not the Headers.

In Excel just check the second row to use as a Filter.

Re: when send to excel,total not displayed when filter is applied

marcus_sommer — Mon, 04 Jul 2016 07:08:46 GMT

You need to include the total row within your filter.

- Marcus

Re: when send to excel,total not displayed when filter is applied

prasadcm — Mon, 04 Jul 2016 07:12:24 GMT

Hi,

when i select a certain customer from Grp Customer as shown below.

I get total of that certain selected customer.

When we export to excel,filter shall be applied on Grp customer & the result should be like above.

What is the use of applying filter on total line?

Regards,

Prasad

Re: when send to excel,total not displayed when filter is applied

prashantbaste — Mon, 04 Jul 2016 07:25:52 GMT

Hello Prasad

It seems you are applying filter in Excel File where your TOTAL's row is a part of Data & not header..

This is difference between QV & Excel features - that when you select some value from dimensions it gives you TOTAL of selected dimension value only where as in Excel it is not case ( or to get you may need to play more with Excel).

Hope this is helpful for you.

Regards,

Prashant P Baste

Re: when send to excel,total not displayed when filter is applied

prasadcm — Mon, 04 Jul 2016 07:26:13 GMT

Hi,

i tried ur way, but

total is not displayed according to filter

Total shown here is without any filter..when we send to excel

Re: when send to excel,total not displayed when filter is applied

prasadcm — Mon, 04 Jul 2016 07:29:55 GMT

Hi Prashant,

Ur right,But i need it in excel.

How am i supposed to do that?

Regards,

Prasad

Re: when send to excel,total not displayed when filter is applied

nilapril2010 — Mon, 04 Jul 2016 07:34:15 GMT

Hi,

It is not 'Send to Excel' issue. Applying filter will show only the filtered rows. After filtering, your total line formula will not be changed. It will be same. You can check the formula bar.

If you want to show the all total after filtering, just include the total row within your filter.

Regards,

Nilanjan

Re: when send to excel,total not displayed when filter is applied

prasadcm — Mon, 04 Jul 2016 08:41:10 GMT

Hi Nilanjan,

What am i supposed to do to get the required output?

Regards,

Prasad

Re: when send to excel,total not displayed when filter is applied

MindaugasBacius — Mon, 04 Jul 2016 08:56:01 GMT

Well, you need to apply formulas to the Excel (SubTotal) or make macro in Qlikview that makes the row Total the dynamic one and exports the report to the Excel:

XLDoc.Sheets(1).Range("B1").Value="=B7+B26+F126+F146"

XLDoc.Sheets(1).Range("B2").Value="=F126+F146"

XLDoc.Sheets(1).Range("B3").Value="=(F126+F146)/(B7+B26+F126+F146)"

Re: when send to excel,total not displayed when filter is applied

nilapril2010 — Mon, 04 Jul 2016 09:00:45 GMT

Hi,

Use SUBTOTAL() function of Excel and try again.

Regards,

Nilanjan