Re: How to write the condition for to separate Q1 ... - Qlik Community

Vamsy1991 · ‎2020-11-13

Please help on to separate Q1 2020 from Submissions of Q1 2020 using subfield

Field name = Quarter

Quarter =Submissions of Q1 2020,Submissions of Q2 2020,Submissions of Q3 2020

PrashantSangle · ‎2020-11-13

Try below

right(subfield(Quarter,','),7)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

tresesco · ‎2020-11-13

@Vamsy1991 Try like:

Load Trim(SubField(Trim(SubField(Quarter, ',')), 'of',2)) as Quarter

MayilVahanan · ‎2020-11-13

Hi @Vamsy1991
One more method is
=Trim(Mid(Quarter, index(Quarter, 'of')+3))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Vamsy1991 · ‎2020-11-13

Thanks for your reply

Vamsy1991 · ‎2020-11-13

Thank you tresesco for your reply

Vamsy1991 · ‎2020-11-13

Thank you Prashant for your reply

How to write the condition for to separate Q1 2020 from Submissions of Q1 2020 using subfield

General Question