topic Re: group in a table in QlikView

group in a table

Anonymous — Thu, 03 Sep 2015 11:01:47 GMT

How to a group like in the excel in a table in qlikview ?

Re: group in a table

gautik92 — Thu, 03 Sep 2015 11:04:46 GMT

use Pivot table it is better for grouping

Re: group in a table

Anonymous — Thu, 03 Sep 2015 11:10:21 GMT

yes I use it , but how to group expressions ? there expression for 2014 then expressions for budget 2015?

Re: group in a table

Anonymous — Thu, 03 Sep 2015 11:44:32 GMT

Hi Jaweher89,

I have occasionally succeeded in dragging the dimension rows to the top, to make them columns, and the expression-columns to the left, which makes them rows.

Re: group in a table

tripatirao — Thu, 03 Sep 2015 12:39:46 GMT

You can use straight table . Go to expression tab, Add two expression you can find Group and Ungroup option.

click on Group option then both expression will be grouped.

Regards

Tripati

Re: group in a table

ChiragPradhan — Thu, 03 Sep 2015 13:31:17 GMT

Hi Jaweher89,,

In Excel, that is just a header or a label. In qlikview, you would need to have it as a dimension. You can then use a condition in your expression to calculate a value based on your dimension values. something like this

hope that helps.

Chirag.

Re: group in a table

Anonymous — Thu, 03 Sep 2015 13:34:21 GMT

can you please add the QVW as attachement ?

Re: group in a table

ChiragPradhan — Thu, 03 Sep 2015 13:57:52 GMT

Hi jaweher89

Please find attached.

regards

Chirag.

Re: group in a table

settu_periasamy — Thu, 03 Sep 2015 14:01:38 GMT

Hi,

Hope you aware, if you have header data in the dimension, you can just drag and drop to the top.

If you don't have, you need to do with Calculated Dimension with Valuelist(Pick(Match(...)))

find attached pivot table with existing dimension.

Re: group in a table

Anonymous — Thu, 03 Sep 2015 15:19:45 GMT

Hi,

Try:

The ValueList () function returns a set of listed values which, when used in a calculated dimension, will form a synthetic dimension. In charts with a synthetic dimension created with the valuelist function it is possible to reference the dimension value corresponding to a specific expression cell by restating the valuelist function with the same parameters in the chart expression.

Below is example where metrics Actual, Budget and Forecast are grouped by current month, Current Year, Previous Year

The Calculated dimension(Pivot this dimension)definition is as follows:

=valuelist('Period','CurrentYear',’PreviousYear’)

Three expressions:

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'Period', Sum({<Year = {'$(=Max(Year))'},Month = {'$(=Max(Month))'} >}Actual),

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'CurrentYear', Sum({<Year = {'$(=Max(Year))'} >}Actual),

if(valuelist('Period','CurrentYear',’PreviousYear’) = ’PreviousYear’, Sum({<Year = {'$(=Max(Year)-1)'} >}Actual)) ) )

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'Period', Sum({<Year = {'$(=Max(Year))'},Month = {'$(=Max(Month))'} >}Budget),

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'CurrentYear', Sum({<Year = {'$(=Max(Year))'} >}Budget),

if(valuelist('Period','CurrentYear',’PreviousYear’) = ’PreviousYear’, Sum({<Year = {'$(=Max(Year)-1)'} >}Budget)) ) )

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'Period', Sum({<Year = {'$(=Max(Year))'},Month = {'$(=Max(Month))'} >}Forecast),

if(valuelist('Period','CurrentYear',’PreviousYear’) = 'CurrentYear', Sum({<Year = {'$(=Max(Year))'} >}Forecast),

if(valuelist('Period','CurrentYear',’PreviousYear’) = ’PreviousYear’, Sum({<Year = {'$(=Max(Year)-1)'} >}Forecast)) ) )

Regards

Neetha