Percentage of row in Pivot

[davehutchinson]

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??

[PrashantSangle]

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

[davehutchinson]

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

[davehutchinson · Accepted solution]

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!