Discussion Board for collaboration on QlikView Scripting.
I tried searching for a post in the forum that might help me but couldn't figure it out.
I want to create a count for my pivot table so that I can see how many refunds was given to an account for a certain reason.
I added the numbers next to each row that will count how many times adj.amount appears
Thank you for all your help
May be like this?
LOAD * Inline [
ACCOUNT, DESC, MONTH, VALUE
A, ABC, 01/04/2016, 65
A, DEF, 01/04/2016, 357
B, GHI, 01/01/2016, 1089
C, JKL, 01/01/2016, 29
D, MNO, 01/04/2016, 27
F, PQR, 01/02/2016, 6
F, PQR, 01/02/2016, 1
F, STU, 01/01/2016, 73
F, STU, 01/02/2016, 80
F, STU, 01/03/2016, 108
F, STU, 01/04/2016, 9
=Pick(Dim, Month(MONTH), 'Count')
=Pick(Dim, Sum(VALUE), Count(VALUE))
Sort Expression for =Pick(Dim, Month(MONTH), 'Count') dimension
=Match(Pick(Dim, Month(MONTH), 'Count'), $(=Concat(DISTINCT Chr(39) & Month(MONTH) & Chr(39), ',', Month(MONTH)) & ',' & Chr(39) & 'Count' & Chr(39)))
I am getting only "December" and "January".
And I don't even have December on my list.
I thought about it, I don't even need to display the count data. I just need to filter those who have a count of more than 3 payments.
Nice Usage of Pick. Sunny please write a blog on Pick function
When i open this file the chart showing like below...
You are the one you actually showed me how to use Pick in getting an additional column.
Try reloading and see what happens
Do you want me to write blog then? stalwar1
Ofcourse, are you waiting for an invitation?
I thought you could write better than me as you are frequently using in different scenarios.