topic Re: Straight table in QlikView

Straight table

oliviatww — Tue, 05 Aug 2014 04:04:55 GMT

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

Re: Straight table

aveeeeeee7en — Tue, 05 Aug 2014 04:11:56 GMT

Use Calculated Dimension:

If(Incident='Yes',Incident)

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

See the Snapshot:

Regards

Aviral Nag

Re: Straight table

amit_saini — Tue, 05 Aug 2014 04:30:07 GMT

Tze,

Please see the attachment.

Thanks,

Re: Straight table

sujeetsingh — Tue, 05 Aug 2014 04:41:56 GMT

You can implement it in two ways

---Use calculated dimension

---Use dimension limits

Re: Straight table

vardhancse — Tue, 05 Aug 2014 05:29:05 GMT

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'

Re: Straight table

oliviatww — Tue, 05 Aug 2014 19:54:36 GMT

Thanks all for the helpful answer. Cheers