CLASS table how to change the amount from 50,000 to 100,000 ?

[paulyeo11]

Hi All

I have create Class table with the help from forum help 4 yr ago.

Table 1 Dimension :-

=class(aggr(sum(sales),year,company),

pick(wildmatch(SOURCE, 'TDSPG',              'TDSS',             'ADL',             'TDSKL',         'TDST'),

            $(iDiffValues) * 1,  $(iDiffValues) * 1,$(iDiffValues) * 1,$(iDiffValues) * 1, $(iDiffValues)*1))

Now my QV doc i don't have field =  iDiffValues , why i am still able produce the table ?

Or My question is how do i change the CLASS setting amount , now is 50,000 , if i need to change to 100,000 , may i know where to change the setting ?

Paul

[johnw · Accepted solution]

Your sample application DOES have a variable called iDiffValues. I changed it to 100,000, and it changed the table. You could set it in script, or add an input box for the variable, enter the new value, and remove the input box.

[paulyeo11]

Hi John

Suddenly you appear in this forum again. Long time no see.

So you back to doing QV again or just one off ?

Paul

Sent from my iPhone

[johnw]

I probably won't be as active as I once was, but I AM back.

[paulyeo11]

‌Hi John

welcome back , I just notice the var it there , it must be list by input only