Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rafaeloneil
New Contributor III

QlikView Doubt

Staff, good afternoon , 


I'm new user of QlikView 11 and would , if possible , that could help me with a question :   I have a table with data arranged as follows ( small sample )

NuContratoCdTipoEstadoDocNmTipoEstadoDocDtContratoCdParceiroNmDocumento
120340002020635PEND. COML24/03/2016247035TERMO VEICULAR
120340002020692FORM. OK27/03/201621336TERMO VEICULAR
120340002022861PEND. DOC01/04/2016202911TERMO VEICULAR
120340002039935PEND. COML01/06/201643894
TERMO VEICULAR

I must tell Contracts ( NuContrato ) grouping them as follows:Indicador.png

Can anyone give me a clue on how to set this view ?

5 Replies
santiago_respane
Valued Contributor

Re: QlikView Doubt

Hi,

You could add a field your desired with Month/Year value and then then add it as a dimension in a pivot table.

Then pivot your expressions by that field, and you'll have the view you want to achieve.

Please let me know if you need more help.

Kind regards,

rafaeloneil
New Contributor III

Re: QlikView Doubt

Santiago , I appreciate your help

I set the Pivot Table with the following items :


DIMENSIONS

1 ) CdParceiroComercial

2 ) = MonthName ( DTCONTRATO )

EXPRESSIONS

1 ) Sum ( QTY )

2 ) Sum ( PND_COML )

3 ) Sum ( PND_DOC )

4 ) Sum ( FORM_OK )

How do I turn empression by MonthName dimension?

You can pass in an example?PivotTable.png

santiago_respane
Valued Contributor

Re: QlikView Doubt

Hi,

After you are done editing properties click OK, and then in your chart grab the header of the dimension you want to pivot ( = MonthName ( DTCONTRATO ) ) and drag it over the expressions in order to pivot it, you will see a horizontal blue arrow indicating the position of the pivoted field.

You must have the Allow Pivoting property activated under presentation tab.

Please let me know if this helps you.

Kind regards,

rafaeloneil
New Contributor III

Re: QlikView Doubt

Now is perfect Santiago ,

I greatly appreciate your help!

santiago_respane
Valued Contributor

Re: QlikView Doubt

Great news Rafael!

Remember to close the thread by marking an answer as correct or helpful.

Kind regards,