Discussion board where members can get started with QlikView.
I have a field 'RIDReportable' which stems from a tick box and holds either 1 (ticked) or -1 (unticked).
What is the correct syntax in the script to translate this so from 35 responses, I can see Yes or No instead of 1 or -1 in the straight table?
1 - 1
-1 - 34
And I wish to show
Yes - 1
No - 34
Go to Solution.
The syntax is: If(PIDReportable =1, 'Yes', 'No')
Hope that helps
Many thanks Jonathan