Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu
Contributor III
Contributor III

Displaying the all data line by line with Particular condition.

Hi All,

I have data like 

F_Name     F_Value    F_Flage

SSP               MFG              Yes

SSP               LTD               NO

SSP               CGF             Yes

SSP               ALG             NO

PPL              MFG             NO

PPL             LTD               Yes

PPL             CGF              Yes

PPL             ALG              YES

CSZ            MFG            Yes

CSZ            LTD              NO

CSZ            CGF            NO

CSZ            ALG             NO

 

 

My Out put is:

In table Box:

F_Name    F_VF

SSP              MFG

                      CGF

PPL              LTD

                      CGF 

                      ALG 

CSZ            MFG                  Like that 

 Logic is :    

F_name is displaying the  F_values  if it is F_Flage is Yes , 

If F_Flages are only Yes that values displaying the that.

I used concate(F_value,chr(10))  --- Here all values are displaying , But i want to displaying only  F_Flage  = Yes  Values,

Help Me.

Thanks 

Ram

 

3 Replies
arulsettu
Master III
Master III

Maybe like this write a calculated dimension

 

if(F_Flage='Yes',F_Value)

Saravanan_Desingh

Are you looking something like this?

commQV37.PNG

Ramu
Contributor III
Contributor III
Author

Hi Saran,

Thanks  for your solution,

I applied that formula ( If(F_Flage='Yes', F_value) and Only function also used , But it's not coming .

my requirement is :

I have taken Table box in qliksense, in that PPL and ssp values will display the single cell like 

PPL  is one row and SSP is one Row , Means Values flage also in single cell 

PPL having 2 Names , these two values will display the single cell .

Thanks,

Ram