Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

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
Master II
Master II

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

Learning never stops.

View solution in original post

3 Replies
pradosh_thakur
Master II
Master II

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

Learning never stops.
danosoft
Specialist
Specialist
Author

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
Master II
Master II

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

regards

Pradosh

Learning never stops.