Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

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.

4 Replies
MVP
MVP

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

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
Valued Contributor II

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

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

MVP
MVP

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

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

paulyeo11
Valued Contributor II

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

‌Hi John

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

Community Browser