Solved: Need help in Pivot Table - Qlik Community

krishna20 · ‎2016-01-21

Hi Folks,

I'm facing an issue calculating metrics in pivot table. I'm having a metric for example SUM(SOHMAX), however user still have an option to choose either base from SSOHMIN or SOHMIN values. It should shown in single column. Is it possible??

Please find the attached sample doc and guide me.

Regards

Krishna

PradeepReddy · ‎2016-01-22

if you are able to reload the application, try my solution as suggested earlier.. it will work..

you need to do small workaround in your application.

1. Create a data island with field values (MM_SOHMAX,MM_SOHMIN,MM_SSOHMIN,APPRSOH) and Name the column as Measure.

2. Reload the application

3. Create a list box with field 'Measure' and choose the option always one selected value.

4. In Pivot Table, add an expression sum(APPRSOH-$(=GetFieldSelections(Measure)))

See the attachment...

View solution in original post

Anonymous · ‎2016-01-21

Try like this at script in [Item Description] table?

Replace [Item Description] field with following code:

If([Item Description]='SSOHMIN' or [Item Description]='SOHMIN', 'SOHMIN', [Item Description]) as [Item Description]

krishna20 · ‎2016-01-21

Hi Balraj,

Thank you for your valuable reply. Sorry to say, I'm not having permissions to reload the script( Not having QVDs). I need to achieve this in front end.Please suggest me .

Anonymous · ‎2016-01-21

No Problem.

Replace that dimension which contain these values as a calculated dimension like this?

Just add this expression as a dimension and replace [Item Description] with your field name

=If([Item Description]='SSOHMIN' or [Item Description]='SOHMIN', 'SOHMIN', [Item Description])

tamilarasu · ‎2016-01-21

Hi Krishna,

Or simply try this expression,

Sum(MM_SSOHMIN) + Sum(MM_SOHMIN)

Anonymous · ‎2016-01-21

Check the attachment,

It was your expression not dimension.

asgardd2 · ‎2016-01-21

You want see sum of two values in expression?

rangesum(MM_SSOHMIN,MM_SOHMIN)

If you want choose possible values you can create two buttons:

First action is clear MM_SSOHMIN.

krishna20 · ‎2016-01-21

Hi Balraj,

The above conditions need to be calculated in the Propose expression . Please check it once in the sample app and guide me further and i need the pivot structure like in sample app only.

krishna20 · ‎2016-01-21

Hi

sunindia‌ , jagan‌ ,tresesco‌

Please light up on this issue. PFA sample excel.

Anonymous · ‎2016-01-21

you want both the expression or only one expression?

Format of sample Pivot in not a concern

Like this?

Need help in Pivot Table

Related Topics