Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Damarlavenkatesh
Contributor

How to delete data in fields through script

Hi all,

I have a pivot table (file attached),here i dont want to show  specific value  in pivot table,is there any option to not to show this value in table?

 

3 Replies
MindaugasBacius
Valued Contributor III

Re: How to delete data in fields through script

There are the few options:
1. Use Set analysis
2. Remove it while loading data with Where statement
3. Use Sheet Triggers to ignore it

Highlighted
Partner
Partner

Re: How to delete data in fields through script

don't know your expression but use set analysis

sum({<Dim2 -={'Jamnagar'}>} value)

Regards

Damarlavenkatesh
Contributor

Re: How to delete data in fields through script

Can you please expalaim me on removing by where statement and sheet triggers?

my data is like

A                        B                                    

usa             SFO

uk                scot

usa             SFO

                     texas

here i want to remove sfo from third  row .