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: 
ramanarayan
Creator
Creator

Issue with aggr function and dimension

Hi Experts,

stalwar123

When i have only 1 dimension(FRCA_WeekYear as Dimension) and with below one expression

Count(Count(TOTAL DISTINCT Aggr(Customer,FRCA_WeekYear)))

i see below in my pivot.. Which is fine..

Capture1.PNG

When i add one more dimension to this (Calc_FRCA_FR_Category), my number changes as per the addtnl dimension... which is fine... But i dont want my numbers to change i need that to be same as we see above.. Is it possible?

Capture1.PNG

10 Replies
shiveshsingh
Master
Master

hi

I couldn't get this line, What do you mean by this?

But i dont want my numbers to change i need that to be same as we see above

ramanarayan
Creator
Creator
Author

Sorry. I did not phrase it correctly.

When adding 2nd dimension, the numbers change which i want to prevent from happening. Anyway i can acheive this

Thanks

sunny_talwar

May be this

Aggr(NODISTINCT Count(DISTINCT Customer), Calc_FRCA_FR_Category)

ramanarayan
Creator
Creator
Author

Sorry Sunny. No luck

Anil_Babu_Samineni

Would you like to share sample?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Janneke
Creator
Creator

Do you mean that you want to duplicate the original table four times? One for each Calc_FRCA_FR_Category?

If so, use a dummy as your dimension:

=ValueList('High','Medium','Low','Never Loggedin')

sunny_talwar

Would you be able to share a sample?

ramanarayan
Creator
Creator
Author

Hi Sunny/Anil,

Attached is the qvw and excel with sample data.

Thanks

ramanarayan
Creator
Creator
Author

added above. Thanks Anil