Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Convert Flag table more dynamic by using SET.

Hi

My Objective is to make my Flag table more dynamic by using SET.

My flag table 1 :-

Expression :-

money(

Sum (if($(ColumnDim3), sales)/1000/$(Columndim89))

, $(vMoneyFormatK))

Dimension :-

=if(

aggr(

(Sum (if($(ColumnDim3), sales)) - Sum (if($(ColumnDim4), sales)))  / Sum (if($(ColumnDim4), sales))

, $(ColumnDim101)) <= $(iDiffValues) / 100

, $(ColumnDim101))

I try convert to SET table 2 :-

Expression :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)

I don't know how to convert dimension to SET ( Table 2) , when i turn on current mth and yr , table not working .

Hope some one can advise me.

Paul

3 Replies

Re: Convert Flag table more dynamic by using SET.

When I click the step 2 button, both the tables don't show anything. Both the tables don't work? What is the expected output?

Capture.PNG

paulyeo11
Valued Contributor II

Re: Convert Flag table more dynamic by using SET.

Hi sunny

I will prepare another new table which is more easy for you to help me.

Pls wait .

Paul

Sent from my iPhone

paulyeo11
Valued Contributor II

Re: Convert Flag table more dynamic by using SET.

Hi Sunny

My QV Table.

Community Browser