Vamsy1991
Contributor
2020-11-13
01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to write the condition for to separate Q1 2020 from Submissions of Q1 2020 using subfield
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
855 Views
6 Replies
PrashantSangle
MVP
2020-11-13
01:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
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 🙂
850 Views
tresesco
MVP
2020-11-13
01:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
848 Views
MayilVahanan
MVP
2020-11-13
01:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Please close the thread by marking correct answer & give likes if you like the post.
843 Views
Vamsy1991
Contributor
2020-11-13
05:01 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply
815 Views
Vamsy1991
Contributor
2020-11-13
05:03 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you tresesco for your reply
815 Views
Vamsy1991
Contributor
2020-11-13
05:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Prashant for your reply
815 Views