Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
oliviatww
Partner - Contributor II
Partner - Contributor II

Straight table

Hi there,

Currently I have a chart straight table that have some fields. One of the field called Incident which is either 'Yes 'or 'No'. My straight table is now showing all the information for yes and no, but what I want is to show only Incident 'Yes'.

Any help would be appreciated. THANKS

Olivia

5 Replies
aveeeeeee7en
Specialist III
Specialist III

Hi

Use Calculated Dimension:

If(Incident='Yes',Incident)

and suppress it. It will only show 'Yes' Data.

See the Snapshot:

Suppress Setting11.png

Regards

Aviral Nag

amit_saini
Master III
Master III

Tze,

Please see the attachment.

Thanks,

AS

sujeetsingh
Master III
Master III

You can implement it in two ways

---Use calculated dimension

---Use dimension limits

vardhancse
Specialist III
Specialist III

in the script level we can restrict only to to get Yes or

we can apply trigger, on open that field value is always 'YES'

oliviatww
Partner - Contributor II
Partner - Contributor II
Author

Thanks all for the helpful answer. Cheers