topic Different graphics on the same sheet QlikView in QlikView

Different graphics on the same sheet QlikView

Tue, 19 May 2015 15:25:23 GMT

Goodmorning everyone.

I'm new to QlikView (excuse me for my english).

How can manage on a single sheet with two charts (see the immage) that represent data in the PIVOT TABLE EXCEL ?

For example, I choose Year and Month and in the sheet view two dashboard that contain the total purchases for the month of January Ink and another must take those starch.

HOW can select the field "C.m." that is the "Merceology Category" (see the immage) directly in the dashboard option ??? (Example "where" syntact or another sentence).

Thanks !!!

Francesco.

Re: Different graphics on the same sheet QlikView

Gysbert_Wassenaar — Wed, 20 May 2015 05:43:50 GMT

Change the expression of one of the two gauge charts from sum([Somma di Importo]) to sum({<[C.m.]=>}[Somma di Importo]). That way one gauge will ignore the selection in the C.m. field and the other gauge will take it into account.

Re: Different graphics on the same sheet QlikView

Wed, 20 May 2015 06:42:05 GMT

Goodmorning and thanks for feedback !!!

If in [C.m.] field (pivot excel) there are many code ? Es. C.m. = 'AM', C.m.='AB', ecc. ... and I have to select only the expression (for example) Cm = 'CO' ... how should I do in expressionn?

=sum({<[C.m.]=>}[Somma di Importo]).

Thanks !!!

Francesco

Re: Different graphics on the same sheet QlikView

Wed, 20 May 2015 06:47:17 GMT

Hello…try this...

=sum({<[C.m.]={'CO'}>}[Somma di Importo]).

Re: Different graphics on the same sheet QlikView

Wed, 20 May 2015 06:56:40 GMT

SIR TRY THIS

EXPRESSION

=sum({<[C.m.]=>}[Somma di Importo])

Re: Different graphics on the same sheet QlikView

Wed, 20 May 2015 07:08:06 GMT

Dear.
Solved !!!!
Excuse me, but are the first times that I use QLIK.

thanks a lot.

Francesco

Re: Different graphics on the same sheet QlikView

Wed, 20 May 2015 08:05:31 GMT

any time welcome sir