Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Percentage of row in Pivot

Hi everyone.  I'm struggling with something which seems very basic.

I want to show a pivot of the number Flows by FlowName by Date.

In Excel this is very easy and looks like this:

This was done by having the "FlowDate" in the rows, with the "FlowName" in the Columns.  Then my Values measure is Count of ID / Count of Date.

But if I try to recreate this in Qlik. Again with Date in the row sna name in the columns.  With the Measure:

Count(FlowSteps_FlowID)/Count(FlowSteps_Date)

It looks like this, and all the calculations are 100% or 0.

If I just do a count in the measure so: Count(FlowSteps_FlowID) I can get the correct counts in number form.

but I really need them as a percentage, and I don't know why Qlik wont do it?

Can anyone help me?  Must be a simple solution surely??

Labels (2)

• ### expression

1 Solution

Accepted Solutions
Contributor III
Author

Have managed to sort it!

Count(FlowSteps_FlowName)/Count(TOTAL<FlowSteps_Date> FlowSteps_FlowName)

So I was told that if you add:

TOTAL<FlowSteps_Date> before you field it will only look at the total of flows for that day, rather than the total overall.

All sorted!

3 Replies

Try below expression.

Count(FlowSteps_FlowID)/Count(Floor(FlowSteps_Date))

If this not work for you then can you share your qvf with us, so that we can work on actual scenario.

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Contributor III
Author

That's just coming up at 100% for all listings. Its really strange... Gonna try starting from scratch.

Contributor III
Author

Have managed to sort it!

Count(FlowSteps_FlowName)/Count(TOTAL<FlowSteps_Date> FlowSteps_FlowName)

So I was told that if you add:

TOTAL<FlowSteps_Date> before you field it will only look at the total of flows for that day, rather than the total overall.

All sorted!