topic Re: How to get data in Date-level granularity as user required way in QlikView

How to get data in Date-level granularity as user required way

Anonymous — Sun, 07 Oct 2018 17:45:12 GMT

Hi All,

i have below like sample data, when user selects Month from the Month-List box, he wants see that month related-years all months data.

Example:

if user selects "March", and in our data March is having data like March-1990, March-1991, March-1999, March-1995, March-2002, March-2006, March-2011.

Now because of 1990,1991,1999,1995,2002,2006,2011 years have march data, User wants to see all 12-months of data from those years(1990,1991,1999,1995,2002,2006,2011)....

in the same way if User selects April, then April alligned years all months data he wants to see in straight table.

A sample data is given below and also the data attached with this mail.

ID	Training Title	Training ID	Status	Registered Date	Training Type
39	Software	A-20120	Completed	1/26/2019	ClassRoom
23	Accounts	A-11607	Cancelled	12/20/2002	Online
7	Maths	A-14448	Waiting	7/23/2008	ClassRoom
11	Medica	A-14749	Withdrawn	7/14/2012	Online
27	Social Sciences	A-10825	In Progress	7/18/2006	Material
26	Languages	A-6609	Completed	8/18/1990	Session
18	Additional Tips	A-4629	Cancelled	5/9/2017	Online

Thanks,
Ravi

Re: How to get data in Date-level granularity as user required way

andrey_krylov — Sun, 07 Oct 2018 18:38:33 GMT

Try this

{$<Month, Year = p(Year) >}

Re: How to get data in Date-level granularity as user required way

Anonymous — Sun, 07 Oct 2018 19:37:07 GMT

Hi Andrey,

And also user is looking for Online%, ClassRoom%, Session% for the selected month related years of every-month(as per above scenario::

if user selects "March", and in our data March is having data like March-1990, March-1991, March-1999, March-1995, March-2002, March-2006, March-2011.

Now because of 1990,1991,1999,1995,2002,2006,2011 years have march data, User wants to see all 12-months of data from those years(1990,1991,1999,1995,2002,2006,2011).

Can you please add this pivot/straight table to in the same dashboard as per scenario.

Thanks in Advance,

Re: How to get data in Date-level granularity as user required way

andrey_krylov — Mon, 08 Oct 2018 06:23:20 GMT

Maybe this