Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a field called FieldNumber. It contains the following values:
ValueNumber | Name |
---|---|
1 | A1 |
2 | A2 |
3 | A3 |
4 | A4 |
5 | A5 |
6 | A6 |
7 | A7 |
8 | A8 |
9 | A9 |
10 | A10 |
11 | A11 |
12 | A12 |
NA | |
NK |
I would like to create a List Box that shows Name values sorted by ValueNumber but also exclude NA and NK values.
How can I do this please?
if you wan to exclude NA and NK you may use this Expression as Long as you only have numbers in other values
if (isnum(ValueNumber), Name)
May be as attached:
In the list box use expression and ignore the data that is gone to be excluded by using e() function in set analysis
How about this
If(valuenumber <> 'na','nk', valuenumber)
PFA for sample solution.
as an alternative to using a calculated Expression inside your list box you could create a subset in your Load Script. This is useful if you want to use this new subset Dimension in many other Charts/Listboxes.
you would do something like this in your script
Table_New:
LOAD
ValueNumber,
Name AS NewDimensionName
Resident Temp_Data
where not match (ValueNumber, 'NA', 'NK');
Or even you do a more simplistic way like this:
Temp_Data:
LOAD * INLINE [
ValueNumber, Name
1, A1
2, A2
3, A3
4, A4
5, A5
6, A6
7, A7
8, A8
9, A9
10, A10
11, A11
12, A12
NA,
NK
];
Table_New:
LOAD
ValueNumber,
Name AS NewDimensionName
Resident Temp_Data
where ValueNumber <> 'NA' and ValueNumber <> 'NK';
Drop Table Temp_Data;
Regards,
MB