topic Using expressions in Graphs in QlikView

Using expressions in Graphs

Fri, 06 Aug 2010 16:29:25 GMT

Hi,

I am new to QlikView and having one issue while designing graphs. The issue is

I had a graph objects which display the sales data for the selected year and year - 1. The expresssions are as below.

Sum

({$<Year={$(=Max(Year))}>} [sales]) and Sum({$<Year={$(=Max(Year)-1)}>} [sales])

This works absolutely fine. Now I have added one expression to this. Here the ReportOn field is from an inline table which has no relation to the sales table.

if(ReportOn='Ledger',Sum({$<Year={$(=Max(Year)-1)}>} [Ledger sales]),Sum({$<Year={$(=Max(Year)-1)}>} [sales]))

This works only when I have not selected any date related filters in my report. If I select a date related filter (say 2009), only the first one works and second one doesn't refresh data. It always gives the [sales] column value.

Is there anything that I am missing in my expressions?

Regards,

Murali

(ReportOn='Ledger',Sum({$<Year={$(=Max(Year))}>} [Ledger sales]),Sum({$<Year={$(=Max(Year))}>} [sales]))

Using expressions in Graphs

shumailh — Sun, 08 Aug 2010 07:08:01 GMT

Hi Murali,

Check your Year field. This is working fine with me see the attachment.

Shumail

Using expressions in Graphs

Mon, 09 Aug 2010 13:16:36 GMT

Hi Shumail,

Thanks for the quick response. I have updated your qvw file with the problem I am facing. Attached is the updated date.

Please note when I select a year and change the 'Report On' value, in the graph, only the selected year values are updating not the year-1 value.

Is this the default functionality of QlikView?

Regards,

Murali

Using expressions in Graphs

Tue, 10 Aug 2010 09:22:32 GMT

Hi All,

Could any one please help me with the above query.

I got struck with this and need to give an update on this ASAP.

If this is not possible using the existing table structure then please let me know.

Thanks in advance.

Regards,

Murali

Using expressions in Graphs

Tue, 10 Aug 2010 09:43:20 GMT

Hi Murali,

I checked your document and it is displaying both selected and previous year data when I change the 'Report On' selection.

I could not identify the issue you mentioned. Can you elaborate in detail?

-Haneesh

Using expressions in Graphs

shumailh — Tue, 10 Aug 2010 09:48:13 GMT

Please check now, the graph was working fine. I put a data grid + in a graph value on data point + freeze the axis values.

Shumail

Using expressions in Graphs

Tue, 10 Aug 2010 09:48:20 GMT

Hi Haneesh,

Thanks for your reply.

The issue comes when you select a particular year and then change the 'Report On'.

For example, if you select year '2008' in the year list, the graph will show 2008 and 2007 data(two bars). After this if you change 'Report On' value, the graph data refreshes only for 2008 (bar in the graph) but not 2007 (bar in the graph).

I hope I am clear this time.

Once again thanks in advance for your help.

Regards,

Murali

Using expressions in Graphs

Tue, 10 Aug 2010 09:56:20 GMT

Hi Murali,

I did the same selection and I can see current and previous year data even after changing 'Report On' selection. I used the document 'Graph MultiDimension1.qvw' attached in your last post.

selection: 2008, Non Ledger

Selection: 2008, Ledger

Using expressions in Graphs

Tue, 10 Aug 2010 10:00:35 GMT

Hi Shumail,

Thanks for the reply.

The problem still exists. Please check my example below.

The data is

Year - Sales - Ledger Sales

2008-2200-2100

2007-1800-2000

When you select year '2008' in the list box and change report on to 'Ledger', the graph shows 2007 (1800) and 2008(2100). Here is the problem as 2007 is showing sales instead it should refresh to ledger sales.

Regards,

Murali

Using expressions in Graphs

Tue, 10 Aug 2010 10:06:35 GMT

Hi Haneesh,

Please check in both cases 2007 value is 1800 only. But for ledger it has to be '2000' and for 'Non Ledger' it has to be '1800' when the year 2008 is selected in the list box.

Regards,

Murali

Using expressions in Graphs

shumailh — Tue, 10 Aug 2010 10:18:47 GMT

Hi Murali,

I know this is not an absolute solution but i found this is working as u were asking...

Shumail

Using expressions in Graphs

Tue, 10 Aug 2010 10:33:05 GMT

Hi Shumail,

I am afraid, this is also not working.

When you select 2008 and 'Non Ledger', the Year-1 value is showing as 2000 but it should show 1800. This is same in table as well as graph.

Any advise?

Regards,

Murali