topic Re: Dynamic Table in QlikView

Dynamic Table

Fri, 12 Apr 2013 20:45:11 GMT

Folks, Please your help.

I'm trying to create the following Dynamic Table, but having a lot of difficulties with the expressions:

BRAND

MODEL

MTD

VAR. m-1

VAR. m-12

Brand: List of all brands

Model: sub group of all models within the brands (User can expand or collapse)

MTD: Number of registers Month to Date (Number of sales in the current period)

%: Percentage that each model represents within the brand (Number of sales of each model / number of sales of the brand)

Share: Percentage that each model represents within the total (All Brands and Models).

Could anyone help me build this table ?

Thanks in advance!

Sat, 13 Apr 2013 07:22:37 GMT

give me a sample data

nilesh_gangurde — Sat, 13 Apr 2013 14:16:52 GMT

it can be done...

please provide the sample data..

-Nilesh

Sun, 14 Apr 2013 20:35:28 GMT

Great Gernan. Thanks for the help!

I included 2 files on the post, with sample data and expected result, so we can proceed.

Sun, 14 Apr 2013 20:36:11 GMT

Very Nice Nilesh. Thanks for the help!

I included 2 files on the original post, with sample data and expected result, so we can proceed.