Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vinayvishwanath
New Contributor II

How to filter the data in QS

Hi All,

we have data in the below format and need to filter only few in them, kindly request to provide the solution for the same

 

 

KeyIT accountMega process Profit Center Sales OrganizationPPM APM Commonality levelShared/Unique classificationPartner WBS Element Paying Org
16909 AOAOBABusiness Adminstration (BA)Y192x212G# 16909xSxxx54x
20319 AOBABABusiness Adminstration (BA)Y192x212G# 16909xSxxx54x
16887 AOOPBABusiness Adminstration (BA)Y218x## 20319xSxxx54x
16891 AOCSDCLDeliver & Develop Customer Loyalty(DCL)Y215x212G# 16887xUxxx54x
16930 AOLKDCLDeliver & Develop Customer Loyalty(DCL)Y215x212G# 16887xUxxx54x
16930 AOGDDCLDeliver & Develop Customer Loyalty(DCL)Y215x212G# 16891xUxxx54x
16930 AOBNDCLDeliver & Develop Customer Loyalty(DCL)Y215x212G# 16891xUxxx54x
16930 AOMJDCLDeliver & Develop Customer Loyalty(DCL)Y215x212G# 16930xUxxx54x

I need to select on OP, CS and BN from the IT account

Thanks

Vinay

2 Replies
YoussefBelloum
Esteemed Contributor

Re: How to filter the data in QS

Hi,

by filterring, you mean on a specific object ? using an expression for example ? or on the back-end (script)

vinayvishwanath
New Contributor II

Re: How to filter the data in QS

Hi Youssef,

In the above data, i am using IT account type as a dimension in bar chart, but i don't want all the objects to be part of it like out of AO, BA,OP,CS,LK,GD,BN,MJ.... I need only OP,CS and BN from the field. Please suggest which one would be better an expression in front end or in back end...(with expression )

Community Browser