Discussion Board for collaboration related to QlikView App Development.
Attached please find the sample Excel and QVW fle. I have a DIm with values A,B,C,D AND E. I want to create a Flag with the three values:
I am able to get 'Only E' and 'No E' but cant get the one with All Values.
How can I accomplish that flag with 3 values
Try this approach
(ooxml, embedded labels, table is Sheet1);
LOAD Distinct Dim,
'No E' as Dim_Flag
Where Dim <> 'E';
'Only E' as Dim_Flag
Where Dim = 'E';
'All Values' as Dim_Flag
View solution in original post