Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this write a calculated dimension
if(F_Flage='Yes',F_Value)
Are you looking something like this?
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