Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
raviqlikview
Contributor II
Contributor II

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

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.

      

IDTraining TitleTraining IDStatusRegistered DateTraining Type
39SoftwareA-20120Completed1/26/2019ClassRoom
23AccountsA-11607Cancelled12/20/2002Online
7MathsA-14448Waiting7/23/2008ClassRoom
11MedicaA-14749Withdrawn7/14/2012Online
27Social SciencesA-10825In Progress7/18/2006Material
26LanguagesA-6609Completed8/18/1990Session
18Additional TipsA-4629Cancelled5/9/2017Online

Thanks,
Ravi

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

3 Replies
andrey_krylov
Specialist
Specialist

Try this

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

raviqlikview
Contributor II
Contributor II
Author

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,

RK

andrey_krylov
Specialist
Specialist

Maybe this