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: 
Not applicable

How do I get % in Pivot Table Measurement - Not Count

I have a spreadsheet that contains the result (Win/Lost/Even) of an Asset (EURUSD/Gold/Google) that I traded on a day which was provided by a Signal Provider, i.e.:

Inline images 3

All I want to know is "Which provider supplied the best (most Wins) signals for the Quarter/Month/Week/Day, and also trending on days of the week(i.e.: Are signals provided by provider 1 mostly good or bad on Mondays?)

I have the Pivot Table setup (correctly I think), but the Result column which is used as a Measure, shows the Count of Win/Lost/Even entries and not the % if Win entries for that day ... I'm stumped

Inline images 4

0 Replies