Skip to main content

Qlik

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
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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: 
akshay61
Contributor II
Contributor II
‎2018-10-13 01:18 AM

QlikSense get values for missing values of quarter of the same year in Pivot Table

Hi,

I am fairly new to QlikSense. I have a pivot chart consisting of "Order ID" as Row, "Year" & "Quarter" As  Column, "Sales" as Measure.

Pivot Screen Shot.png

The requirement is to get the values for the quarter having no values or 0 values of the same year if any one quarter  is having value.

For Example : In the above screen shot For Order ID = 100463807, Year= 2012 Q1 is having value 77700.24, I want to have same value for  the remaining Quarters of the same year For same Order ID.And Also if the value of measure is 0 or no value, then it should first check for the values is next quarters and then in previous Quarters.

Thanks,

Akshay

243 Views
0 Likes
0 Replies