Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Pivot Table

I am attempting to Create a pivot table to show available inventory.

My first dimension is 'PriceScale' my second dimension is 'secDelimit'.

For my measure, I am attempting to use an expression of =COUNT(IF(AVAILABLE = '1', SEAT_NUMBERAVAIL))

At present, my table looks as is (attached)

What is happening is that my expression is not refining to the secDelimit as is intended. The quantity of 390 is the aggregate total of all seats that fit the criteria of AVAILABLE =1.

Is my expression incorrect or does my problem lie elsewhere

 

7 Replies
Nicole-Smith

You would be better off writing your expression using set analysis:
COUNT({<AVAILABLE = {'1'}>} SEAT_NUMBERAVAIL)

However, the expression isn't the issue considering the behavior you are describing.  I would start by looking at your load script/table viewer and making sure all of your joins/links are performing properly and not duplicating any data.

EvanBarrick
Creator
Creator
Author

Thank you for the response. This is my current table structure:

Availability

(Joined to PACING via 'EVENTCODE')

Contains the fields 'AVAILABLE' and 'SEAT_NUMBERAVIL'

Pacing

(Joined to MANIFEST via 'PRICESCALE')

Manifest

Contains the field 'secDELIMIT'

 

I do not have any Synthetic keys being created or loops

EvanBarrick
Creator
Creator
Author

Here is the full table structure (attached)

My Pivot table is constructed as follows;

Dimensions:

ROW: PRICESCALE

COLUMN: secDELIMIT

Expression: =COUNT({<AVAILABLE = {'1'}>} SEAT_NUMBERAVAIL)

Nicole-Smith

From your explanation, I can't find anything wrong with what you're doing.  Can you please post an example document?  It's the only way I'll be able to see if there is something else going on.

EvanBarrick
Creator
Creator
Author

Does this work?

Nicole-Smith

I'm unable to figure this out without some kind of sample data.

Without the data, I can only suggest creating a Table with dimensions PRICESCALE, secDELIMIT, SEAT_NUMBERAVAIL, and AVAILABLE.  This should allow you to see if there are rows of values related to PRICESCALE and secDELIMIT fields that shouldn't be.  There has to be some kind of unexpected data joining/relation that is causing values to be displayed across everything.  There's no reason that the chart itself wouldn't split the values out by the dimensions.

EvanBarrick
Creator
Creator
Author

Thank you for your help