Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

javier_florian
Contributor III

Create a new dimension

Hi Everyone,

I have the follow information:

Month          Category          Product          Value

Feb               1                    Emission          $917

Feb               1                    Cancellation     -$25

Feb               2                    Emission          $892

Feb               2                    Cancellation     -$873

So, for business reasons, users need view in a sheet the information filtering Category 1 but in the pivot table Category 1 and Category 2 with Cancellation:

Month          Product          Value

Feb               Emission          $917

Feb               Cancellation     -$25

Feb               2 - Emission    -$873

*Note that sheet has an action filtering Category = 1 when user enable sheet.

I hope be clear with explanation.

Regards,

- Javier

1 Solution

Accepted Solutions

Re: Create a new dimension

See attached example.


talk is cheap, supply exceeds demand
6 Replies

Re: Create a new dimension

See attached example.


talk is cheap, supply exceeds demand
javier_florian
Contributor III

Re: Create a new dimension

It was so easy... Do you have documentation about work with that expression?

Regards,

- Javier Florián

Re: Create a new dimension

See here


talk is cheap, supply exceeds demand
javier_florian
Contributor III

Re: Create a new dimension

Hi Wassenaar,

I have an additional issue,... the requirement was modified:

CategoryProduct GroupProduct
1Emission         Emission        
1Cancellation    Cancellation   
1Cancellation    Devolution
2Emission         Emission        
2Emission         Throwback
2Cancellation    Cancellation   

Sheet filter applies when Category = 1, my graph shows values by Product Group, but I need add to chart values when Product = Throwback

Is possible with set expression?

Thanks in advanced.

Re: Create a new dimension

If you always want to show Cancellation and Throwback then modify the expression to:

sum({$+<Product={'Cancellation','Throwback'},Category=>}Value)


talk is cheap, supply exceeds demand
javier_florian
Contributor III

Re: Create a new dimension

Great, regards Wassenaar!

Community Browser