Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
sunbaj12
New 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_Table.PNGCurrent Chart DisplayRequirement.PNGRequirement but has to be sorted as in the post

Labels (1)
2 Solutions

Accepted Solutions
Highlighted
Partner
Partner

Re: Show only specific records in table

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

Partner
Partner

Re: Show only specific records in table

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
Highlighted
Partner
Partner

Re: Show only specific records in table

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

Partner
Partner

Re: Show only specific records in table

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