topic Re: Convert Flag table more dynamic by using SET. in QlikView

Convert Flag table more dynamic by using SET.

paulyeo11 — Thu, 17 Mar 2016 05:59:26 GMT

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

sunny_talwar — Thu, 17 Mar 2016 08:51:30 GMT

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?

paulyeo11 — Thu, 17 Mar 2016 09:00:44 GMT

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 — Thu, 17 Mar 2016 09:18:55 GMT

Hi Sunny

My QV Table.