How to calculate average of text values

[#1]

Hi,

How can average of text values be calculated in a Pivot in Qlick view.

Like its very simple in Excel that you can calculate percentage average of "Y" or "N" in a column.

Thanks in advance.

KRs/Asad

[#2]

Hi,

You want to calculate the contribution(Column %) in a pivot

Thanks & Regards

[#3]

yes but how would i do that, what expression do i need, or which option?

[#4]

Hi

Check with the below forum

http://community.qlik.com/forums/t/41916.aspx

Thanks & Regards