Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to write the expression

Hello All,

can any one help me in achieving this requirement.....the thing is i need to show sum of volume against recommended R_Calmonth column  what i mean is

Capture.PNG

what i need to show for   R_Calmonth      201707 =201704+201705+201706 which is  1600+1600+1768  =4968

                                 for                            201708=201704+201705+201706 +201707 which is   1600+1600+1768+400=5368

                                                                  201709=201704+201705+201706 +201707+201708 which is   1600+1600+1768+400=5368(beacuse i dont have any volume for 201708)

Expression i tried is

                             Actual:  Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=max(CALMONTH))"}>} VOLUME)

                             

but i am not getting expected output

Capture1.PNG

Any suggestion plz

thanks

Naveen

13 Replies
shraddha_g
Honored Contributor III

Re: how to write the expression

can you share sample app?

shraddha_g
Honored Contributor III

Re: how to write the expression

Try

Sum({<CALMONTH = {">=$(=date(YearStart(Max(CALMONTH)),'YYYYMM')) <$(=date(max(CALMONTH),'YYYYMM'))"}>}

kunkumnaveen
Contributor III

Re: how to write the expression

i wish but i am having client data with me,i will loose my job

shraddha_g
Honored Contributor III

Re: how to write the expression

You can create a Sample app to test with Dummy data with same scenario.

It will be easy to help you better to understand you data and  data model

kunkumnaveen
Contributor III

Re: how to write the expression

I tired your expression but it is not working it is coming as nulls

shraddha_g
Honored Contributor III

Re: how to write the expression

How R_CalMonth and CALMONTH are related?

kunkumnaveen
Contributor III

Re: how to write the expression

based up on

part,supplier,plant,fiscalyear combination

kunkumnaveen
Contributor III

Re: how to write the expression

Capture2.PNG

Based up Key6

kunkumnaveen
Contributor III

Re: how to write the expression

Any Suggestion on how to write the expression please

Community Browser