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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator II
Creator II

aggr not working

Hi,

I have the below sample data.

Krish2459_58_0-1701080291348.png

I need the output like Accural type aggregation which should show 3 rows like above and the table should have only Savings_year as dimension.But Iam got sing row like below.

 

Krish2459_58_1-1701080496589.png

 

Thanks..

 

Labels (2)
2 Replies
TcnCunha_M
Creator III
Creator III

Hello
I don't think is this is possible , sorry but let me questioned you
Why you need Only the Year with the 3 values, but no information where that values come from, i don't think is readable in an easy mode, because we don't have any idea where that value came from, i believe this way might be little bit better no?
because you can may know where the value came from, or you make Pivot table 

TcnCunha_M_0-1701091580595.png

TcnCunha_M_1-1701091660617.png

 

As you think, so shall you become.
vincent_ardiet_
Specialist
Specialist

 If you want to see your result per Saving_Year, this field should also be present in the Aggr statement, else QS cannot allocate the data to it.