Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make QS divide by 4 instead of 12 ?

Hi All

My Table 1 give wrong value for 2016 Average stock = 0.457 million

Because it divide by 12 instead of 4.

The reasons is after i add the target table into my QVF doc.

Now if you click on year = 2016 , you notice that it display yearmonth from jan till Dec , it have 12 month.

any way to make it divide by 4 ?

My Question is how to make 0.457 million to 1.37 million ?

Next post i will post my QVF file.

Paul

1 Reply
paulyeo11
Master
Master
Author

my QVF

file name end we ver01 display correct value

file name end we ver02 display wrong value