Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Front End Logic Calculation

Dear All,

Need a small help to build a logic at front end.

I have attached a simple test file(attached) which is I am getting in my report but I have to achieve the result of target excel(attached).

Flow:

I am getting a dynamic value through a variable say VDyanmicvariable=50 which is Initial OutStanding, now I have required fields to calculate Closing OutStanding.

and for next month, my initial outstanding will be closing outstanding of previous month.

Please suggest, how I can calculate at front end???

Regards,

Balraj

18 Replies
MarcoWedel

Hi,

maybe

var1=min(total Date)

and

if(Date=$(var1) ...

could work.

min(Date) in an expression when using Date as dimension should deliver just the same Date value per Date/Dimension value.

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Say,

If user select a Calender 2014, Apr the my makedate() function will make it 1st April 2014 and in variable value will be 50 as per last thread.

How min(Date) which will return 1st April 2014 only would work similar to previous to previous functionalities??

Anonymous
Not applicable
Author

Here each time I need current and previous values of sales till my Closing Outstanding becomes<0.

I have done this at back end but now things are dynamic, I have to calculate them at front end only

I need a function which would work similar to previous() at front end.

Pls Suggest.

jyothish8807
Master II
Master II

Tried this also,but didnt work

Regards

KC

Best Regards,
KC
MarcoWedel

Hi,

I'm not quite sure about what you like to achieve with this expression, but tried for a solution.

Is this what you are looking for:

QlikCommunity_Thread_135249_Pic4.JPG.jpg

regards

Marco

Anonymous
Not applicable
Author

It is required for Daily Sales Outstanding.

and it should be like this:

DateInitial O/SSalesCollectionClaimsClosing O/SDays
Apr-14502010555<120
May-14551551055<120
Jun-14551010550<120
Jul-14501510550105
Aug-14501081042104
Sep-14421010103284

Closing Outstanding would be compared with current sales and previous sales.

We can write one more if statement to make it <120 days.

Anonymous
Not applicable
Author

Hello Marco,

It is required for Daily Sales Outstanding.

and it should be like this:

DateInitial O/SSalesCollectionClaimsClosing O/SDays
Apr-14502010555<120
May-14551551055<120
Jun-14551010550<120
Jul-14501510550105
Aug-14501081042104
Sep-14421010103284

Closing Outstanding would be compared with current sales and previous sales.

We can write one more if statement to make it <120 days.

Any update on this???

Anonymous
Not applicable
Author

Marco,

Yes, I am looking for similar kind of column to add...

Could you help me to get this expression?

Regards,

Balraj

Anonymous
Not applicable
Author

KC,

Have you got any success to get this field NewColumn say Days?

Marco had done this but not getting any response from him..

Regards,

Balraj