Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
Hello…try this...
=sum({<[C.m.]={'CO'}>}[Somma di Importo]).
SIR TRY THIS
EXPRESSION
=sum({<[C.m.]=>}[Somma di Importo])
Dear.
Solved !!!!
Excuse me, but are the first times that I use QLIK.
thanks a lot.
Francesco
any time welcome sir