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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
FabioManniti
Contributor III
Contributor III

Funnel Chart, ignore dimension filter in measure

Hello, I have some data with a dimesion called status which can be: "suggested", "notified", "rejected", "delivered", "accepted".

I would like to see how many proposal do I have on average per status and per day in a Funnel Chart.

Now, my measure would be:

COUNT({<status={"suggested"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))

COUNT({<status={"delivered"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))

COUNT({<status={"accepted"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))

....

In this way I have a number for ALL days.

But If I put this code in the funnel chart I get different outputs because it will only count the days where that status is true.

How can I "tell" my funnel chart to count ALL dates regardless the status?

Labels (2)
1 Solution

Accepted Solutions
FabioManniti
Contributor III
Contributor III
Author

Ok, nevermind.

I found the solution myself.

I must add ALL inside count.

COUNT(distinct id)/COUNT(ALL distinct Date(Floor(created_at), 'MM/DD/YYYY'))

View solution in original post

1 Reply
FabioManniti
Contributor III
Contributor III
Author

Ok, nevermind.

I found the solution myself.

I must add ALL inside count.

COUNT(distinct id)/COUNT(ALL distinct Date(Floor(created_at), 'MM/DD/YYYY'))