Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aamertaimor
Contributor III
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

7 Replies
qlikmsg4u
Specialist
Specialist

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

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.

prashantbaste
Partner
Partner

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

awhitfield
Partner
Partner

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

sunny_talwar

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
Specialist II
Specialist II

Hi,

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

Comm_172638.png

qlikmsg4u
Specialist
Specialist

!Then Find the attached example !