Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Fix column in a diagramm sum table

Hello together,

i have problems with a Diagramm Table Sum.

In the following you see the filtes of the table:

Year
2014
2013
Nature
Actual

Forecast I

Forecast II
Last year

Month

MonthMonthMonth
1234
5678
9101112

Here you see the Diagramm Tabel Sum

ActualForecastLast Year
Revenueit should Show always the actual figures (filter ofit should choicable for the Forecast I oder IIit should Show always  the last year filter
Forecastit works
Gross Margin

I Need help of the columns. The first colum works, if I click a other filter (eg. Forecast 1) it Shows the actual. But in the second column it Shows me the choicable Filter (eg. last year, forecast I or forecast II).

How can I fix the forecast column to Show me only forecast I or forecast II?

How can I fix the Last year column, that it Shows me always the Last Year Filter.

Does anyone can help me.

Thanks.

Jörn

1 Solution

Accepted Solutions

Re: Re: Fix column in a diagramm sum table

See attached example.


talk is cheap, supply exceeds demand
3 Replies

Re: Fix column in a diagramm sum table

Actual: sum({<Nature={'Actual'}>}Value)

Forecast: sum({<Nature={'$(=only(Nature))'}*{'For*'}>}Value)

Last Year: sum({<Nature={'Last Year'}>}Value)


talk is cheap, supply exceeds demand
Not applicable

Re: Fix column in a diagramm sum table

Thank you for this quick Response.

How I get this three formulas in the Formula field

Formulas.jpg
Do I Need a Conditional in the field.

Thank you.

Re: Re: Fix column in a diagramm sum table

See attached example.


talk is cheap, supply exceeds demand
Community Browser