topic Re: Efficient expression and data model for QVW (cumulated margin by month) in QlikView

Efficient expression and data model for QVW (cumulated margin by month)

Fri, 25 Apr 2014 08:13:35 GMT

Dear Dariusz,

Can you show me how to have a more efficient expression and datamodel for the attached QVW files.

Kind regards

Michael

Fri, 25 Apr 2014 08:59:03 GMT

Michael,

look for first idea and let me know what do you think about this direction?

regards

Darek

Fri, 25 Apr 2014 09:31:04 GMT

And 2'nd direction.

I know, that there may be some differences, but let me know which direction you prefer ....

regards

Darek

Mon, 28 Apr 2014 06:37:20 GMT

Dear Mariusz,

Thank you for your two examples

I think this solution is better because i need it to have in chart object.

Can you explain me what you want to mean with the value tech_month?

Kind regards

Michael

Mon, 28 Apr 2014 07:53:54 GMT

for exampleMichael,

as tech_month i named additional dimension connected to oryginal month dimension.

Each tech_month value is connected to oryginal months used in your cumulated calculations.

So, we have data structure like this:

tech_month, month

1,1

2,1

2,2

3,1

3,2

3,3

......

thanks it for example 5'th tech month "knows" months, and, what is most iportant, also data for months 1-5.

So, if we put tech_month as dimension, we will have in each row of our chart data from all month we would like to accumulate in this row.

Of course it is still possible (uing set analysis) to show in this row some other KPI using data, where tech_month=month.

Let me know if you have additional questions or need more help.

regards

Darek