Displaying the all data line by line with Particular condition.

[Ramu]

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

[arulsettu]

Maybe like this write a calculated dimension

if(F_Flage='Yes',F_Value)

[Saravanan_Desingh]

Are you looking something like this?

[Ramu]

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