Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

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
Valued Contributor III

Re: Straight table

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
Honored Contributor III

Re: Straight table

Tze,

Please see the attachment.

Thanks,

AS

sujeetsingh
Honored Contributor III

Re: Straight table

You can implement it in two ways

---Use calculated dimension

---Use dimension limits

vardhancse
Valued Contributor III

Re: Straight table

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'

Partner
Partner

Re: Straight table

Thanks all for the helpful answer. Cheers