topic Re: YTD,QTD,MTD in App Development

YTD,QTD,MTD

ravindraa — Wed, 09 Mar 2016 12:44:50 GMT

Hi All,

I have struck one place please give me any suggestion to come out , my requirement is i have to crate the chart with two expression like sum(Grosssales) and sum(netsales)

here i have to give selections for YTD , QTD,MTD, if user select YTD the corresponding chart should be display the YTD values and if user select QTD he corresponding chart should be display the QTD values, if users select MTD he corresponding chart should be display the MTD values but wrote one condition in Edit script level but it is showing o value .

kindly give me some suggestion,

please find the attached document.

Thanks in advance..........

Re: YTD,QTD,MTD

Anonymous — Wed, 09 Mar 2016 13:13:09 GMT

did you check this?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: YTD,QTD,MTD

ravindraa — Wed, 09 Mar 2016 13:20:03 GMT

Hi Balarj thanks for replay.

I have seen but when we select YTD the chart should be display the YTD value , if we select QTD na chart should be display the QTD , if we select MTD the chart should be display the MTD values.

if we write set analysis in chart level we need 3 charts one chart of YTD ,one chart for QTD, one chart of MTD i think .

is there any option in edit script level

please give me suggestion

thanks in advance.

Re: YTD,QTD,MTD

Anonymous — Wed, 09 Mar 2016 13:35:09 GMT

No, try like this?

Create a Inline Function at script:

Step1)

Expression:

Load * inline

[EID, EName

1, YTD

2, QTD

3, MTD

];

Step2)

Then take EName in List box and arrange it like we do for Calender.

Step3)

Take one Chart only and use the Conditional display of expression in Chart on the base of EName selection, like we do in Adhoc reports for Expression to Display

Adhoc reporting in Qlikview

Ad-Hoc Reporting in Qlikview

Re: YTD,QTD,MTD

ravindraa — Thu, 10 Mar 2016 02:09:53 GMT

Hi Balraj Ahlawat,

Thanks for reply but i need to create dashboard in Qliksense not in qlikview, i think there is no future in qliksense like qlikview could you give me suggestion in back end level for fiscal year Apr to Mar.

Thanks in advance.