Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
alexcill
New Contributor III

Re: Variable dimensions

It drives me crazy... .It works in the attached .qvw but when I change it in mine .qvw, it doesn't...  There are only three dimensions, but two to choose... I understand that you only have changed vCritDimension for:

=If(GetSelectedCount(Dimension)>0, '[' & Concat (DISTINCT Dimension,  ' ') & ']')

Highlighted

Re: Variable dimensions

Also, created a new field in the script

LOAD Origen,

    Articulo,

    [Cliente NIF],

    [Grupo Cliente],

    Articulo&[Cliente NIF] as [Articulo Cliente NIF],

    Y,

    M,

    D,

    [Venta Neta]

FROM

(ooxml, embedded labels);

LOAD * INLINE [

Dimension

'Cliente NIF'

'Articulo'

];

View solution in original post

alexcill
New Contributor III

Re: Variable dimensions

Perfect!!! Thanks a lot, Sunny!