Credit Card

[satish4]

Hi guys, This my Credit card no 1453 8976 0034 3420. let i Know This like **** **** **** 0043, 1453 **** **** ****, 1453 **** **** 0043 any chance possible?

Ex: - like this one

[MartW · Accepted solution]

Hi @satish4 ,

I think this is what you need

Load *,
left(Number,4) & ' **** **** ' & right(Number,4) 	as middle,
'**** **** **** ' & right(Number,4) 				as right,
left(Number,4) & ' **** **** ****'	 				as left
;
test:
Load * inline [
Number
1453 8976 0034 3420
];

[anat]

as well you can use the mid function to get desired output.

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFuncti...

[satish4]

Hi Guys,

Need legend when small bar chart please help anyone me.

Ex: Like this one 

In that bar chart i want to legend.