topic Re: Average Trend Line in QlikView

Average Trend Line

Thu, 19 Mar 2015 13:33:28 GMT

Hello,

I have a list with different products and after selecting one of that products, then I can select different sub-products.

I would like to create a graph where at the same time I wanna see:

- Trend line for the sub-product

- Average line (flat) for its product

In order to compare how the sub-product is going vs. the global (see below).

The problem in Qlikview is that when I select the sub-product, all the information in the graph refers to it. So I don't know if there is a way to block one line or something like that.

Sorry to write with key-words but I cannot put names because of confidentiality.

Re: Average Trend Line

stigchel — Thu, 19 Mar 2015 14:06:40 GMT

Hello Borja,

Something like:

Sum({<SubProduct>} TOTAL <Product> Value)

Where {<SubProduct>} is the set analysis for disregarding the selection in SubProduct and

TOTAL <Product> is for disregarding the dimension (if present)

Re: Average Trend Line

stigchel — Wed, 25 Mar 2015 10:01:25 GMT

Has this answered your question? If so, can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.

Re: Average Trend Line

Wed, 25 Mar 2015 13:32:06 GMT

Hi,

I haven't tried yet because my code it's a bit more tricky, but I think this could work. I'll respond as soon as I have results.

Thank you

Re: Average Trend Line

Wed, 25 Mar 2015 14:59:25 GMT

I've tried with a similar expression and now it's working! The idea of using {<SubProduct>} in order to block the SubProduct selection was really usefull.

Thank you for your help