Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
10 Replies
Highlighted
Master
Master

Re: Issue with aggr function and dimension

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

Highlighted
Creator
Creator

Re: Issue with aggr function and dimension

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

Highlighted

Re: Issue with aggr function and dimension

May be this

Aggr(NODISTINCT Count(DISTINCT Customer), Calc_FRCA_FR_Category)

Highlighted
Creator
Creator

Re: Issue with aggr function and dimension

Sorry Sunny. No luck

Highlighted

Re: Issue with aggr function and dimension

Would you like to share sample?

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)
Highlighted
Creator
Creator

Re: Issue with aggr function and dimension

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')

Highlighted

Re: Issue with aggr function and dimension

Would you be able to share a sample?

Highlighted
Creator
Creator

Re: Issue with aggr function and dimension

Hi Sunny/Anil,

Attached is the qvw and excel with sample data.

Thanks

Highlighted
Creator
Creator

Re: Issue with aggr function and dimension

added above. Thanks Anil