ITD calculation in qlikview

[srinivas1921]

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......

[ElizaF]

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..

[srinivas1921]

Hi Eliza,

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

[xavieravinson]

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..........

[ElizaF]

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?

[srinivas1921]

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........

[ElizaF]

Can you upload the file?

[xavieravinson]

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