Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sreenivasareddy
Contributor II
Contributor II
‎2021-06-02 03:56 PM

Chart

Dear all,

I want below format in QlikView Pivot Table

1)Here  APR 2020 to Apr-2021 Month Values and  YTD MAR-2021 and FY 20 are expressions

how to get simple way to achieve this instead of writing 42 expressions  please help me for this.

 

APR 2020MAY 2020JUN 2020JUL 2020AUG 2020SEP 2020OCT 2020Nov 2020Dec 2020Jan-2021Feb-21Mar-2021Apr-2021YTD MAR-2021FY 20
BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%BaseAchConv%
Labels (1)
Labels
292 Views
0 Likes
0 Replies
Community Browser