Average Trend Line

[#1]

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.

[stigchel]

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)

[stigchel]

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.

[#4]

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

[#5]

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