Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

aamertaimor
New Contributor III

Remove unecessory data


hi,

I need to remove data from dimension and fact table which is not required. I tried both keep and exists functions but somehow couldn't figure out how to eliminate the rows i don't want.

input.jpg

I also attached qvw and see if you can help me in this.

Many thanks,

aamertaimor

Tags (1)
7 Replies
qlikmsg4u
Valued Contributor

Re: Remove unecessory data

You want to remove unwanted data from Data model or in just front end?

If it is front end create a straight table and add Workorder1 and Name as dimensions and Sum(pay) as expression.

don't forget to check Suppress when Value is Null in Name Dimension

Highlighted
aamertaimor
New Contributor III

Re: Remove unecessory data

Thanks QIKmsg4u but i want this in the script because i have very big table. I think bringing in front end will consume lot of memory.

Partner
Partner

Re: Remove unecessory data

Hi

Tick ✓ to 'Omit if value is Null' option for coloumn 'Name'  if its a tablebox (Properties -> Presentation Tab).


Else if its a Pivot Table/Straight Table - Tick ✓ to 'suppress when value is null' option.


Hope this will resolve your problem.


--

Regards,

Prashant P Baste

Partner
Partner

Re: Remove unecessory data

Hi Muhammad<

1. Change to a Straight Table Dimension = Workorder1 and Name

2. Flag Name Dim - 'Suppress When When is Null'

3. Set the  Expression = Sum(pay)

4. Presentation tab - Suppress Zero values and Suppress Missing both ticked

HHT - Andy

See the attached

Re: Remove unecessory data

Try this script:

discipline:

LOAD * inline

  [

  Workorder1,Name

  1,Muhammad

  2,James

  3,Katie

  4,Martin

  ];

GL:

LOAD * inline

  [

  Workorder, Pay

  a1, 10

  a1, 50

  a2, 10

  a2, 40

  a2, 10

  a3, 10

  a4, 15

  a5, 79

  a5, 65

  a9, 46

  ];

GL1:

NoConcatenate

Load Right(Workorder,1) as Workorder,

         Sum(Pay) as Pay

Resident GL

Where Workorder <> 'a4'

Group By Workorder;

DROP Table GL;


GL2:

NoConcatenate

Load Workorder as Workorder2,

         Pay

Resident GL1

Where Exists(Workorder1, Workorder);

DROP Table GL1;

GL3:

NoConcatenate

LOAD Workorder1 as Workorder2,

           Name

Resident discipline

Where Exists (Workorder2, Workorder1);

DROP Table discipline;

krishna20
Valued Contributor II

Re: Remove unecessory data

Hi,

Try as in the image.You will get desired result.

Comm_172638.png

qlikmsg4u
Valued Contributor

Re: Remove unecessory data

!Then Find the attached example !