topic How to write set analysis for taking monthly data? in QlikView

How to write set analysis for taking monthly data?

Thu, 22 Oct 2015 04:45:45 GMT

Hi experts,

I want to take a data from 1st of this month till today...How can I write set analysis on tran_date??

I write this one but it is not working...

tran_date={'>=$(=floor(monthstart(max(tran_date))))'}

Re: How to write set analysis for taking monthly data?

settu_periasamy — Thu, 22 Oct 2015 05:01:15 GMT

Hi,

is that giving the number format? , then try like

tran_date={'>=$(=monthstart(floor(max(tran_date))))'}

Re: How to write set analysis for taking monthly data?

jonathandienst — Thu, 22 Oct 2015 05:01:26 GMT

Hard to say without more understanding of your model and how its being used . The set expression looks OK, so you need to explain what is not working. An uploaded example qvw is the best. I would simplify the expression a little, like this:

tran_date={">=$(=monthstart(max(tran_date)))"}

But is the user selecting tran_date, or are they selecting other calendar fields like month, year etc? You might need to override these, like

tran_date={">=$(=monthstart(max(tran_date)))"}, Year=, Month=

Re: How to write set analysis for taking monthly data?

Thu, 22 Oct 2015 05:09:17 GMT

Hi jonathan,

I am calculating good recieving note(GRN) bill amount for this month till today...I wrote this-

sum

(

tran_date={'>=$(=monthstart(floor(max(tran_date))))'}

stock_tran_in_prod_value // it is amount for one bill

)