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
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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
338 Views
0 Likes
0 Replies