topic Re: Daily Total in Pivot table in QlikView

Daily Total in Pivot table

Tue, 21 Jun 2016 06:57:39 GMT

I'm trying to have in my pivot table market coverage ratio. During basket analysis I have similar information to below:

Date
Product type
Unit sold for this product
Transaction count for his product for this day
I need found information about total transaction for this day for all products

thought that will be easy and simple set analysis will solve problem but it doesn't work.

I really don't want add this information to additional table in loading script.

marcus_sommer — Tue, 21 Jun 2016 07:39:14 GMT

Try something like this. count(TOTAL <A> C)

- Marcus

Anonymous — Tue, 21 Jun 2016 07:46:02 GMT

Hi Piotr,

You are using Straight table, if you use this chart, use marcus_sommer‌ solution.

If you do it with Pivot Table, show subtotals.

I have attached one example with two options.

Regards!!

er_mohit — Tue, 21 Jun 2016 07:46:05 GMT

Try this

Aggr(NODISTINCT Count(C),A)

Tue, 21 Jun 2016 07:49:16 GMT

I used Marcus formula and it's fine. Thank you for help.