Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
marcobombo1
Contributor
Contributor

How to show all values of a calculated dimension in a straigth table

Hello,

I would like to display a straight table with a dimension that is the year with all its values, even if I have selected the year in the list box. I tried with this calculated dimension =aggr(only({1<year=>} year),year), but it doesn't work.

Any ideas? I attach small example.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You'll have to override  the selection in the measure too: sum({<anno>}anz)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

You'll have to override  the selection in the measure too: sum({<anno>}anz)


talk is cheap, supply exceeds demand
marcobombo1
Contributor
Contributor
Author

Thanks Gysbert, it works great!!!