topic Re: QTD in Master Calendar ? in QlikView

QTD in Master Calendar ?

Tue, 29 Oct 2013 16:35:09 GMT

Hi Experts,

I have data at Monthly Level and I am able to create Master Calendar in QlikView to have Quarter, Semester and YTD.

Now , I need to create QTD (Quarter to Date) and STD (Semester to Date) also in which I am having problem.

I am attaching Sample QVW file with data. Kindly help me to create QTD and STD in Master Calendar.

Thanks,

Kumar

Re: QTD in Master Calendar ?

Gysbert_Wassenaar — Tue, 29 Oct 2013 17:26:18 GMT

See attached example.

Re: QTD in Master Calendar ?

Tue, 29 Oct 2013 17:26:34 GMT

http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

Re: QTD in Master Calendar ?

Tue, 29 Oct 2013 19:01:05 GMT

Thanx a Lot Wassenaar .

One More thing, Now I have 3 flags for QTD , STD and YTD.

In Front End (QV Application), In listbox , I need to have 3 Contents basically QTD, STD and YTD. If User selects QTD from the list box, he/she gets data filtered for QTD in QV application amd similarly for STD and YTD.

Kinldy let me know how achieve this ?

Thanx

Kumar

Re: QTD in Master Calendar ?

Wed, 30 Oct 2013 05:38:36 GMT

Hi Octavio, Thanx for reply. I need to have the metric calculation using Master Calendar Not through separate set analysis expression for QTD,YTD etc.

Regards,

Kumar