Chart Expression or column filter based on another selection.

[#1]

Hi everyone,

I'm a newbie on Qlikview reporting so help is appreciated.

I currently have a request from business to create a dashboard that has line and graph charts. I have a table with dates and amounts, and I want to be able to compare a particular month with a pre-defined month (say, always January) for that same year. So, if the user selects March 2015, then I'd plot march 2015 amount as an expression, and another expression which plots January 2015, both in the same chart. Else if the user selects June 2012 then it would plot against January 2012.

On another, perhaps more complicated requirement, I need to plot information of the current quarter, while the second expression/column displays information of the current Quarter -1. For example, a chart would display  Q1 2015 vs Q4 2014, Q2 2015 vs Q1 2015, Q3 2015 vs Q2 2015 and finally Q4 2015 vs Q3 2015.

I know how to do this in SQL with stored procedures, but doesn't seem like the best idea to keep fetching data from SQL when the information is already loaded in the qvds.

[sunny_talwar]

It might be easier to help if you are able to share a sample with us to look at? Would you be able to provide one?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[sasikanth]

HI Javier,

For Re1:

Exp1: Default (JAN)

Sum({<Month={'JAN'}>}sales) //can use Month Number here

Exp2: user selected ;

=SUM({<Month={$(=Month(max(Date)))}>}Sales)

REQ2:

Use functions like QuarterStart() and QuarterEnd()

Exp1:

SUM({<Trans_Date={">= $(=QuarterStart(Max(Trans_Date)))<=$(=QuarterEnd(Max(Trans_Date))) "}>}sales)

Exp2: (Previous Quarter)

SUM({<Trans_Date={">= $(=QuarterStart(Max(Trans_Date)),-1)<=$(=QuarterEnd(Max(Trans_Date)),-1) "}>}sales)

Please check Date formats once.