topic Expression col outside of group in QlikView

Expression col outside of group

Thu, 09 Jul 2015 08:36:14 GMT

Hi All,

struggling to achive some functionality. Looks like below.

Group Dimension -------------------------------------------------->

Dimension 1 ¦ Dimension 2 ¦ Col Expression1 ¦ Col Expression2 ¦ Col Expression2 ¦ Col Expression2

So basically, i dont want Col expression1 to be grouped. Possible?

Re: Expression col outside of group

MK_QSL — Thu, 09 Jul 2015 08:44:59 GMT

May be you can use Col Expression 1 as a Calculated Dimension with Aggr in Pivot Table.

But without looking your sample file or application, difficult to give an accurate reply.

Re: Expression col outside of group

Gysbert_Wassenaar — Thu, 09 Jul 2015 08:45:53 GMT

I'm afraid I don't understand what you're trying to do. Can you give an example? Perhaps a mockup of the result in an excel file?

Re: Expression col outside of group

Thu, 09 Jul 2015 08:55:24 GMT

sure, the expressions are averages based on a dynamic date range, The grouping effectively provides the detail.

Re: Expression col outside of group

Gysbert_Wassenaar — Thu, 09 Jul 2015 09:19:27 GMT

Ok, you can try using two calculated dimensions for the 12wk Avg and 4wk Avg columns. If you have a Date field then those expressions would look something like this:

aggr(avg({<Date={'>$(=max(Date)-84)<=$(=max(Date))'}>}Value),Supplier,Product)

aggr(avg({<Date={'>$(=max(Date)-28)<=$(=max(Date))'}>}Value),Supplier,Product)

Re: Expression col outside of group

Thu, 09 Jul 2015 09:28:58 GMT

Perfect! Thank you Gysbert!