topic Re: Expression Question in QlikView

Expression Question

sterno14 — Wed, 25 Nov 2020 16:16:04 GMT

If I have data like below:

Data
Time Period	Coverage	Amount
19-20	A	150000
19-20	B	150000

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

Time Period	Amount
19-20	150000

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.

Re: Expression Question

dplr-rn — Thu, 11 Apr 2019 16:37:15 GMT

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?

Re: Expression Question

sterno14 — Thu, 11 Apr 2019 17:02:28 GMT

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.

Re: Expression Question

dplr-rn — Thu, 11 Apr 2019 17:17:19 GMT

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;