
Creator III
2020-01-02
02:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Generate Quarter with extra values
have a column Quarter containing values Q1,Q2,Q3 and Q4.
I want to generate a column TempQuarter in script such that the values are connected as -
Quarter | TempQuarter |
Q1 | Q1 |
Q1 | Q1 Actual |
Q1 | Q1 Plan |
Q2 | Q2 |
Q2 | Q2 Actual |
Q2 | Q2 Plan |
Q3 | Q3 |
Q3 | Q3 Actual |
-------- and so on till Q4 | -------- and so on till Q4 |
- Tags:
- qlikview_scripting
502 Views
1 Solution
Accepted Solutions

Creator III
2020-01-02
03:10 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
got an answer to this. Initially left join was not working as the former quarter values had trailing spaces.
1 Reply

Creator III
2020-01-02
03:10 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
got an answer to this. Initially left join was not working as the former quarter values had trailing spaces.
