Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a pick and match formula with a dimension (not a variable) and I'd like to show a default value if no value is picked.
$(=Pick(Match((Grouping1),'Option1',
'Option2')
,'[Option1]'
,'[Option2]'
))
I thought of something like:
if(Count(Grouping1)=1, $(=Pick(Match((Grouping1),'Option1',
'Option2')
,'[Option1]'
,'[Option2]'
)),Option1)
Anyone knows the right syntax for it?
For me it worked well - just tested (whereby in qlikview).
- Marcus
Just do
Pick( 1+Match( someField, baseVal1, baseVal2 ), convertVal_default, convertVal1, convertVal2 )
Match returns 0 when no items matches. Plus 1 to shift it back, such that Pick get you the first item as default when no match is found.