QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

Any suggestion plz

thanks

Naveen

13 Replies
Honored Contributor III

Re: how to write the expression

can you share sample app?

Honored Contributor III

Re: how to write the expression

Try

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

Contributor III

Re: how to write the expression

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

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

Contributor III

Re: how to write the expression

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

Honored Contributor III

Re: how to write the expression

How R_CalMonth and CALMONTH are related?

Contributor III

Re: how to write the expression

based up on

part,supplier,plant,fiscalyear combination

Contributor III

Based up Key6

Contributor III

Re: how to write the expression

Any Suggestion on how to write the expression please