Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to Qlikview
What is KeepChar and PurgeChar give me an example
plz help.
You got a good thorough answer from @msKarthikeyan . I just want to point out that both parsmeters in the the functions are strings (text) you should use single quotations even hard coding the parameters like this:
Keepchar( 'qlik1234', '1q2' )
And
Purgechar( 'qlik1234', '1q2' )
When comparing a field to string you do like this
Load
KeepChar(FieldName, '1q2' ) as Kept,
KeepChar(FieldName, '1q2' ) as Purged,
Amount
Inline [
FieldName, Amount
qlik123, 3
Join234, 1
]
Please be sure you close out your thread by using the Accept as Solution button on the post(s) that got you the information you needed, this gives credit to the posters and lets the other Members know what helped. Please be sure to circle back and complete this to properly close things out.
Regards,
Brett