Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sterno14
Contributor II
Contributor II

Expression Question

If I have data like below:

Data  
Time PeriodCoverageAmount
19-20A150000
19-20B150000

 

And in my chart I want to display for rolled up Time Period as:

Time PeriodAmount
19-20150000

 

How can I write chart expression? If there are different amounts within the same Time Period then the sum would display. But looking for when amount is same. 

 

Thanks.

 

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Dont think theres an easy way to do in expression
it maybe better to do it in script.
Are you saying coverage is not related to amount at all?
sterno14
Contributor II
Contributor II
Author

Thanks. Basically 150000 is the total for both coverages. But we only have an overall figure. But if the user chooses Coverage A then 150000 should display and same if they choose Coverage B. In this case the total amount does apply to each coverage. 

dplr-rn
Partner - Master III
Partner - Master III

i dont understand your full picture but try something like below
dont load amount into the main table. create another table which has the amounts by timeperiod

load distinct TimePeriod,Amount from source;