topic Re: Chart with sum in QlikView

Chart with sum

danosoft — Mon, 16 Oct 2017 16:01:57 GMT

Hi i have the situation in the picture.

I want to show in the round chart the number of Sum of my Items i have 2 tables (the one table show only DataStart but i have a column named Items; the second table show the DataFinish with column Items)

how can i show in chart the difference from count of items from table 2 and table 1?

like: count(items table2) - count(items table1)

thanks

Re: Chart with sum

pradosh_thakur — Mon, 16 Oct 2017 17:16:23 GMT

May be

in the script

add an extra column

Item as Item1 in table 1

Item as Item2 in table 2

then count(item1)-count(item2)

regards

Pradosh

Re: Chart with sum

danosoft — Tue, 17 Oct 2017 06:36:05 GMT

but if i choose a DateStart in table 1 i want the chart refresh it with count(items table2) - count(items table1) for the date i choose, the same thing if i choose DateFinish in table2

Re: Chart with sum

pradosh_thakur — Tue, 17 Oct 2017 07:50:59 GMT

It shall change as it will be associated i guess. did you give a try ?

regards

Pradosh