Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ZimaBlue
Creator
Creator

Total sum is ignoring one dimension - Qlik Sense Enterprise

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)

Labels (3)
2 Solutions

Accepted Solutions
ZimaBlue
Creator
Creator
Author

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!

View solution in original post

ZimaBlue
Creator
Creator
Author

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!

View solution in original post

5 Replies
chrismarlow
Specialist II
Specialist II

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Specialist II
Specialist II

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
Creator
Creator
Author

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!