topic ITD calculation in qlikview in QlikView

ITD calculation in qlikview

srinivas1921 — Wed, 28 Dec 2016 17:05:20 GMT

Hi all,

Couldu please clarify that what is ITD and also uprovide expression for ITD. We have year filter and month filter,we want to show the ITD values according to the both filter selections in the bar chat.

It would be greatful if u r provide any example on ITD.

Thanks......

Re: ITD calculation in qlikview

ElizaF — Wed, 28 Dec 2016 20:25:22 GMT

ITD is the Year To Day - YTD indicator?

If your answer is YES, find some examples in the links below:

YTQ, QTD, MTD and WTD

YTD calculation in QlikView - Simple Example needed..

Re: ITD calculation in qlikview

srinivas1921 — Wed, 28 Dec 2016 23:16:27 GMT

Hi Eliza,

It is not YTD. It is Inception to date(ITD).

Re: ITD calculation in qlikview

xavieravinson — Thu, 29 Dec 2016 05:32:14 GMT

Hi Srinivas,

Create two variables

vStartDate=min({1} Datefield)

vEndDate=max(Datefield)

Inside the set analysis you have to exclude the filters selection like Year, Month..........

Re: ITD calculation in qlikview

ElizaF — Thu, 29 Dec 2016 07:18:57 GMT

Ok, I understand. Sorry, I have not used this indicator .

From the first link with examples, you can adjust the expression for ITD like this:

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={"<=$(=Max(DateNum))"}>} Sales)

or you can use the solution posted by Xavier with variables, but in both cases you must have the Date field (DateField) in Calendar table.

Can you upload the file?

Re: ITD calculation in qlikview

srinivas1921 — Thu, 05 Jan 2017 17:15:20 GMT

Hi,

The expression which are provided by Eliza and Xavier working fine but in our chart (ITD by month)

when we select year and month then stack bar chart will shows only single bar ITD value for selected month. Is it valid scenario?

As per my understanding, when user selecting year and month till this selection all months needs to display from starting year to selected year but it was not displaying in our chart.

We excluded all selection in our expression but still it is showing for single month only.

Please suggest solution on this and suggest that what is the behavior of ITD in the char.

Thanks for u r great support........

Re: ITD calculation in qlikview

ElizaF — Thu, 05 Jan 2017 17:43:00 GMT

Can you upload the file?

Re: ITD calculation in qlikview

xavieravinson — Fri, 06 Jan 2017 05:41:43 GMT

Hi Srinivas,

If you use the above variables it will show as per the selection. And you have to make sure the always selected one option is disabled in your dimension Month or Year.

With Regards,

XavieRavinson