topic Re: Pivot Chart Issue Urgent Help Needed in QlikView

Pivot Chart Issue Urgent Help Needed

Tue, 15 Aug 2017 21:47:47 GMT

Hello,

I a requirement where I need to compare 2 rows/periods and show the amount from min(period) only when the filing indicator is different for both periods.

I cannot flatten the file in Load script because I will have multiple year of data in same. I need to show the same in Pivot chart. Please Help.

Re: Pivot Chart Issue Urgent Help Needed

Nicole-Smith — Tue, 15 Aug 2017 22:06:56 GMT

Dimensions:

Filing Group
Entity
PERIOD
FILING_IND

Expression:

sum({<Entity={'=count(distinct FILING_IND)>1'}>}Field)

I've also attached a working example.

Re: Pivot Chart Issue Urgent Help Needed

Tue, 15 Aug 2017 22:11:29 GMT

Hello Nicole,

The result should only show Sum of Min Period.

Re: Pivot Chart Issue Urgent Help Needed

Nicole-Smith — Tue, 15 Aug 2017 22:52:07 GMT

That's different than the result you have in Test.xlsx...

I'm not sure if you want this:

Dimensions:

Filing Group
Entity
PERIOD
FILING_IND

Expression:

min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)

Filing Group	Entity	PERIOD	FILING_IND	min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)
TEST	8Z	201612	1	598
	8Z	201705	0	598
	F4	201612	1	-13520000
	F4	201705	0	-13520000

Or this:

Dimensions:

Filing Group
Entity
=aggr(min(PERIOD), [Filing Group], Entity)

Expression:

min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)

Filing Group	Entity	=aggr(min(PERIOD), [Filing Group], Entity)	min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)
TEST	8Z	201612	598
TEST	F4	201612	-13520000

If you want something different, please provide what the output should look like.

Re: Pivot Chart Issue Urgent Help Needed

Fri, 29 Sep 2017 05:57:21 GMT

Hi Nicole,

I have more than one filing group and I want the sum by each filing group by Entity Id where filing ind is different in both year

Re: Pivot Chart Issue Urgent Help Needed

Fri, 29 Sep 2017 05:59:59 GMT

it works when i select one filing group but when i select more than one filing group it doesn't work

it starts showing entities even when the filing ind is not different in both years