Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunbaj12
Contributor
Contributor

Show only specific records in table

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 DisplayCurrent Chart DisplayRequirement but has to be sorted as in the postRequirement but has to be sorted as in the post

2 Solutions

Accepted Solutions
DavidM
Partner - Creator II
Partner - Creator II

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.

 

View solution in original post

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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.

 

View solution in original post

2 Replies
DavidM
Partner - Creator II
Partner - Creator II

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
Partner - Specialist III
Partner - Specialist III

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.