Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

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 !