Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table

Hi

I have a pivottable with an expression population and calls. If i add  a dimension Period the calls should separated by Period but the population

should not change! See attached excel sheet.

Do you have any iedas?

Thanks

Juri

1 Solution

Accepted Solutions
kuba_michalik
Partner - Specialist
Partner - Specialist

Maybe use this:

Count (DISTINCT {$<Jahr=,Monat=,PROD=,OWNERLOGIN=,Periode=,DETAIL=,Kontakttyp=>} TOTAL<New_Area> CID)

for the Population expression. This will make the expression ignore all chart dimensions except New_area (as this is the one you want to keep) .

View solution in original post

3 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

Maybe use this:

Count (DISTINCT {$<Jahr=,Monat=,PROD=,OWNERLOGIN=,Periode=,DETAIL=,Kontakttyp=>} TOTAL<New_Area> CID)

for the Population expression. This will make the expression ignore all chart dimensions except New_area (as this is the one you want to keep) .

Not applicable
Author

Thanks! Works perfectly! One more thing! Because only 2 Periods have Calles in but because of the population he now shows all the periods. How

Can I suppress  Periods without Calls?

Thanks

Juri

kuba_michalik
Partner - Specialist
Partner - Specialist

Like that:

If(Count (DISTINCT TOTAL<Periode> ROW_ID)>0,Count (DISTINCT {$<Jahr=,Monat=,PROD=,OWNERLOGIN=,Periode=,DETAIL=,Kontakttyp=>} TOTAL<New_Area> CID))

Basically, the condition is Calls expression, with TOTAL<Periode> added just in case there is a New_Area with no calls in some period (presumably you wouldn't like to show nothing for Population in that case). If you can be absolutely sure there will be no cases like that, TOTAL<Periode> is not necessary and you coud write it like this:

If([Calls]>0,Count (DISTINCT {$<Jahr=,Monat=,PROD=,OWNERLOGIN=,Periode=,DETAIL=,Kontakttyp=>} TOTAL<New_Area> CID))