Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

d_caprelli
Contributor II

Chart with sum

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

1 Solution

Accepted Solutions
pradosh_thakur
Valued Contributor III

Re: Chart with sum

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

3 Replies
pradosh_thakur
Valued Contributor III

Re: Chart with sum

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

d_caprelli
Contributor II

Re: Chart with sum

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

pradosh_thakur
Valued Contributor III

Re: Chart with sum

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

regards

Pradosh

Community Browser