topic Re: need expression help in QlikView

need expression help

Mon, 16 Jun 2014 13:47:20 GMT

Hi all,

have 2 month data of stocks and their closing prices. objective is to derive how many days closing price has increased from its previous day and throw the number of days in an expression in straight table. below is the desired output:

Stocks No of days upticks from previous day

IBM 10

GOOG 5

MS 20

Please let me know way forward

thanks,

Sukhwant

Re: need expression help

MK_QSL — Mon, 16 Jun 2014 13:50:38 GMT

Sample data please !

Re: Re: need expression help

Mon, 16 Jun 2014 14:00:58 GMT

here you go

thanks

Sukhwant

Re: need expression help

hic — Mon, 16 Jun 2014 14:09:21 GMT

A similar calculation is done here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/16/counters-in-the-load

HIC

Re: need expression help

MK_QSL — Mon, 16 Jun 2014 14:16:54 GMT

Are you sure the data your have provided are giving the same result you expected in question?

Re: need expression help

Mon, 16 Jun 2014 14:22:28 GMT

@ Manish - data provided is different from desired result in Question. point is to get an idea on how to make an expression based on the data provided

@ Henric - thanks for the response, but that article suggests solution by amending the script. i want to explore if this can be handled in dashboard only by not touching script.

thanks,

Sukhwant

Re: need expression help

Anonymous — Mon, 16 Jun 2014 14:40:28 GMT

Hi,

if(previous(STOCKS)=STOCKS and previous(CLosing_Price) < CLosing_Price, RangeSum(1,Peek(No_of_Days_Count)), 1) as No_of_Days_Count

Write the above code in the script and use the field as an expression in the Chart

Re: need expression help

Mon, 16 Jun 2014 14:49:08 GMT

@ Karthigayan - as mentioned earlier, dont want to amend the script. will appreciate if can get a solution in the dashboard expression only

thanks in advance

Sukhwant

Re: need expression help

Anonymous — Mon, 16 Jun 2014 15:04:35 GMT

Try with this expression:

=if(Stocks=Only({<Datefield={'=$(=Date(Datefield-1,'MM/DD/YYYY')})'>}Stocks) and CLosing_Price=Only({<Datefield={'=$(=Date(Datefield-1,'MM/DD/YYYY')})'>}CLosing_Price),

RangeSum(Above(No_of_Days_Count,1,1)))