Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Chart Issue Urgent Help Needed

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.

5 Replies
Nicole-Smith

Dimensions:

  1. Filing Group
  2. Entity
  3. PERIOD
  4. FILING_IND

Expression:

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

I've also attached a working example.

Not applicable
Author

Hello Nicole,

The result should only show Sum of Min Period.

Nicole-Smith

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

I'm not sure if you want this:

Dimensions:

  1. Filing Group
  2. Entity
  3. PERIOD
  4. FILING_IND

Expression:

  1. 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)
TEST8Z2016121598
2017050598
F42016121-13520000
2017050-13520000

Or this:

Dimensions:

  1. Filing Group
  2. Entity
  3. =aggr(min(PERIOD), [Filing Group], Entity)

Expression:

  1. 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)
TEST8Z201612598
F4201612-13520000

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

Not applicable
Author

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

Not applicable
Author

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