Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
OmarBenSalem

Need help

Hi all ( stalwar1‌) ,

I did not know how to explain what I'm aiming for with a title, but here am I elaborating it:

I have

YearCreation : Represents the year of the creation of an account

YearAction : Represents the Year of the action

What I currently have :

Capture.PNG

Dim1 : YearCreation

Dim2: YearAction

Measure: count(distinct IdAccount)

=> This to show the year of creation of the accounts % the year of the publication (action)

Now, what I want to do is, keep the same thing, but removing the second dimension, and show only ONE LINE.

I mean, having something like this: (these numbers) in one line.

Capture.PNG

How should I transform my measure?

I tried : Count(distinct{<YearAction=p(YearAction)>} IdAccount)

But this give me "wrong" numbers:

Capture.PNG

Any hint please?

1 Solution

Accepted Solutions
sunny_talwar

Are you sure you used DISTINCT in your expression Omar?

Sum(Aggr(Count(DISTINCT IdAccount), YearCreation, YearAction))

View solution in original post

6 Replies
sunny_talwar

May be you want this

Sum(Aggr(Count(DISTINCT IdAccount), YearCreation, YearAction))

OmarBenSalem
Author

Still no

Capture.PNG

OmarBenSalem
Author

Wait a second ! Is it true that the new Line Chart should contain the same numbers as in the bar chart?

I mean, if in the YearCreation = 2017, we have 200 139 accounts between actions made in YearAction=2017 and 2018.

Now, if we suppose that there are accounts that intersect those 2 years (made actions in both years)

Wouldn't them be counted one time and thus we'll have lesser accounts?

I mean, would this expression (logically) work?

and if so, maybe the result is true?

Count({<YearAction=p(YearAction)>} ID_COMPTE)

Capture.PNG

sunny_talwar

Are you sure you used DISTINCT in your expression Omar?

Sum(Aggr(Count(DISTINCT IdAccount), YearCreation, YearAction))

vkish16161
Creator III
Creator III

Try

Count({<YearAction=p(YearCreation )>} ID_COMPTE)


P and E functions should ideally be used on tables that don't have linkage between them.

OmarBenSalem
Author

I was just forgetting sthing really important; stupidest thing ever; i was not including a flag to only count the accounts that have actions -_-

That was STUPID

Sum(Aggr(Count(DISTINCT {<Flag13MAction={1}>} ID_COMPTE), [AnnéeCreationCompte], YearAction))

Now it works fine !

Capture.PNG