topic Pivot Table in QlikView

Pivot Table

soha1902 — Mon, 09 Feb 2015 10:13:56 GMT

Hi All,

I created one report using Pivot Table. Where I am using three columns 1. Product, 2. Active Date and 3. Deactive Date.

I pivoted date field so if date field comes under Active Date and Deactive date then it will show 40 for particular product else null.

See below screenshot:

this report showing the correct data but as per requirement I dont want to include Activated and Deactivated column in report. Please see below screenshot:

If I remove These 2 fields then this report not showing data for Prod A because its having the 2 Active and Deactive date.

Please find the demo app in attachment.

Thanks.

Re: Pivot Table

Anonymous — Mon, 09 Feb 2015 10:22:22 GMT

Here you go

Re: Pivot Table

soha1902 — Mon, 09 Feb 2015 10:31:26 GMT

You removed Active and Deactive column from Chart1. Now its also not showing data for Prod A. I want to remvoe Active and Deactive column but also want to show the values for Prod A.

Re: Pivot Table

Anonymous — Mon, 09 Feb 2015 11:09:08 GMT

was that in your "Chart I am Looking"?

I don't see that.

Can you elaborate the requirement?

Re: Pivot Table

arulsettu — Tue, 10 Feb 2015 04:18:34 GMT

can you post data source like excel

Re: Pivot Table

soha1902 — Tue, 10 Feb 2015 05:42:37 GMT

Any suggestions please.

Re: Pivot Table

tresB — Tue, 10 Feb 2015 05:51:28 GMT

Put your if expression within sum(), like: Sum(if(Date>=Activated and Date<= Deactivated,40,0))

Does it help?