Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
joshabbott
Creator III
Creator III

Level of Expansion in a Pivot Table

Hello,

I'm looking for a way to determine if a pivot table is showing the final column (fully expanded in a row).  I have 4 dimensions in this pivot table:

Course

Division

Category

Name

I also have 2 expressions:

Training Date (which =max(Training Date))

Count of Students (count distinct Name)

If a user has expanded a pivot table to where they can see 'Name', I'd like to hide the second expression (Count of Students), because it just shows a bunch of 1's.  Is this possible?

Thanks!

4 Replies
awhitfield
Partner
Partner

HI Josh,

can you post an example qvw?

Andy

mov
Champion III
Champion III

I don't think it's possible.  Even if it was - what to do if Name dimension is expanded only for one Course value?

marcus_sommer
MVP & Luminary
MVP & Luminary

It might be possible to query this per macro. But macros aren't recommended and won't work within a AJAX client. Therefore the answer is no. But maybe you could use another approaches to display your data. Maybe with dimension-groups or several chart-objects (within a container) with specialized sights and expressions or ...

- Marcus

petter
Partner
Partner

You can remove the display of 1 if you have it drilled down to the individual student level by

having this expression:

    If( Dimensionality()<4,Count(DISTINCT Name),'')


2015-05-18 #1.PNG