group in a table

[Anonymous]

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

[gautik92]

use Pivot table it is better for grouping

[Anonymous]

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

[Anonymous]

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.

[tripatirao]

Hi

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

[ChiragPradhan]

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.

[Anonymous]

can you please add the QVW as attachement ?

[ChiragPradhan]

Hi jaweher89

Please find attached.

regards

Chirag.

[settu_periasamy · Accepted solution]

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.

[Anonymous]

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