Total sum is ignoring one dimension - Qlik Sense Enterprise

[ZimaBlue]

Hello! 

I have a pivot table in which the row represents the advertising campaign, and the column is my measure.

I'm trying to calculate the total number of users, but still considering ONLY the campaign and two more parameters (and ignoring all the others). But any expression shows me just the total amount at all. (only the filter with variables works. that is, I get the full amount for the period from variables, and the campaign and partner columns are still ignored)

camp	regCount
camp1
camp2

I checked several similar questions in the community, but none of the formulas helped me.

One of options i try:

count({<campaign, partner_name, signup_time= {">=$(vDateFrom)<=$(vtodayDate)"}>} total user_id)

[chrismarlow]

Hi,

Not tested, but maybe try using 1 to ignore all selections then P() to bring back in campaign & partner_name?

count({1<campaign=P({$ campaign}), partner_name=P({$ partner_name}), signup_time= {">=$(vDateFrom)<=$(vtodayDate)"}>} total user_id)

Cheers,

Chris.

[ZimaBlue]

Hello!

Unfortunately, this gives an empty cell (

I'm trying to at least count the TOTAL ignoring ALL dimensions. But even this doesn't work, because when I set the filter, the amount changes, although it should always remain total. So there is no difference if I wrote total or not.

I also tried to enclose count total inside aggr, but the result remains the same. 

[ZimaBlue · Accepted solution]

I solved my question differently: I made two different pivot tables with different calculation logic for each of the types of metrics. "TOTAL" more or less works in this form.

It suits me temporarily. I haven't found a universal solution yet. Thanks for the help!

[chrismarlow]

Hi,

I'd got the syntax on P() function wrong ... looking at your solution not sure it is actually what you are after (i.e. using TOTAL in a chart to 'ignore' dimensions vs ignoring selections through set analysis).

Cheers,

Chris.

[ZimaBlue · Accepted solution]

I tinkered with it a bit and I got it with:

count({1 <campaign=P(campaign), partner_name=P(partner_name), [signup_time]= {">=$(vDateFrom)<=$(vtodayDate)"}>} distinct [user_id])

It works

Thank you!