32
Scale N-Grid
Grid
*GRIDSR (scale)
A *GRIDSR variant where columns are numeric scale points (e.g., 0–10 for NPS). Each row stores the selected scale value. Supports maxvalueof[] and maxvalueindexof[] for identifying top-rated items.
Script Definition
script definition (.q)
*GRIDSR 'Q32' 'On a scale of 0–10, how likely are you to recommend each brand?' *GRIDLIST 'NPSScale' 0:0 1:1 2:2 3:3 4:4 5:5 6:6 7:7 8:8 9:9 10:10 / 1:Berger 2:Asian Paints 3:Nippon /
Use in Expressions
expressions
valueof[Q32.1]>=9 -- Berger is a promoter (NPS 9 or 10) valueof[Q32.1]<=6 -- Berger is a detractor (NPS 0–6) maxvalueof[Q32]>=9 -- at least one brand rated 9+ maxvalueindexof[Q32]=2 -- Asian Paints received the highest NPS
maxvalueof[Q32] returns the highest value across all rows. maxvalueindexof[Q32] returns the 1-based row index of that maximum.
Ideal for NPS and satisfaction scale grids where you need to identify the top-rated item.