Show only specific records in table

[sunbaj12]

Hi I am new to qliksense and I am tying to create a table. I want to show only specific records in the table. Currently my table looks like below.

I would like to show data only where State is Active, New, On Hold or Resolved and it should be sorted by - New, Active,On Hold and then Resolved irrespective of the data in them. How can I achieve this. 

Current Chart DisplayRequirement but has to be sorted as in the post

[DavidM · Accepted solution]

For showing only some states, you can either use filter or set analysis. Like this:

Count( {<State=-{'Cancelled'}>}category) - it is easier to not count cancelled state as you count every other state, that's why - in the condition. In chart select to show only non zero values.

For custom sorting you need to use dual function in load script.

[Arthur_Fong · Accepted solution]

If you can get the second screenshot up, the only requirement left here is to sort according to:

New, Active,On Hold and then Resolved.

At script, create a Sort Table like this:

 SortTable:

load * inline [

State, Sort

New,1

Active,2

On Hold,3

Resolved,4

];

Reload your data then at your dashboard, click on the table properties > sorting > state > custom >expression > insert the field sort > check sort numerically > ascending.