topic Re: Need help in Pivot Table in QlikView

Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 07:03:48 GMT

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

Re: Need help in Pivot Table

Anonymous — Thu, 21 Jan 2016 07:10:03 GMT

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]

Re: Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 07:13:16 GMT

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 .

Re: Need help in Pivot Table

Anonymous — Thu, 21 Jan 2016 07:18:06 GMT

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])

Re: Need help in Pivot Table

tamilarasu — Thu, 21 Jan 2016 07:20:22 GMT

Hi Krishna,

Or simply try this expression,

Sum(MM_SSOHMIN) + Sum(MM_SOHMIN)

Re: Need help in Pivot Table

Anonymous — Thu, 21 Jan 2016 07:21:22 GMT

Check the attachment,

It was your expression not dimension.

Re: Need help in Pivot Table

asgardd2 — Thu, 21 Jan 2016 08:06:42 GMT

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.

Re: Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 08:58:51 GMT

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.

Re: Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 09:16:11 GMT

sunindia‌ , jagan‌ ,tresesco‌

Please light up on this issue. PFA sample excel.

Re: Need help in Pivot Table

Anonymous — Thu, 21 Jan 2016 09:59:24 GMT

you want both the expression or only one expression?

Format of sample Pivot in not a concern

Like this?

Re: Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 10:33:35 GMT

Hi Thank you,

I Think this idea may works.Can you make it as sample file for me??

Re: Need help in Pivot Table

asgardd2 — Thu, 21 Jan 2016 10:56:32 GMT

Sample with two buttons.

Re: Need help in Pivot Table

krishna20 — Thu, 21 Jan 2016 13:01:06 GMT

You Mentioned

You want see sum of two values in expression?

No, I should not sum two values at a time. I need to show SUM(MM_SOHMAX) as default.

User can see what is the value for SUM(MM_SOHMIN) or SUM(MM_SSOHMIN).

How can a user select other metrics in the same expression, when we are using single expression to show??

Re: Need help in Pivot Table

krishna20 — Fri, 22 Jan 2016 04:52:52 GMT

Than you Anton for your inputs.

Sorry there is an lack of explanation from my side. Pardon me for that.

Let me clearly explain with an another example.

Having a Dimension and 4 Expressions in Pivot table. Like Sum( X), Sum(A), Sum(B), Sum(C).

I need to insert another column with an expression of Sum(A-X) by default.

If the user want to see what's the value for Sum(B-X) or Sum(C-X) in the same expression(The values B or C should replace when those selected) . How can it be done??

edited :

In X ->> APPROH

In A->>MM_SOHMAX

In B-->>MM_SOHMIN

In C->> MM_SSOHMIN

I hope its clear ..Please let me know if any inputs needed..

Re: Need help in Pivot Table

PradeepReddy — Fri, 22 Jan 2016 05:44:15 GMT

see the attachment.. might be helpful for you..

Re: Need help in Pivot Table

krishna20 — Fri, 22 Jan 2016 05:59:26 GMT

Thank you pradeep for your valuable reply.

It's a nice approach. But, I'm having three values here,

In A->>MM_SOHMAX

In B-->>MM_SOHMIN

In C->> MM_SSOHMIN which needs to subtract from X ->APPROH.

edit:

I'm applying your logic. But it's showing result as null.

=sum($(=GetFieldSelections(APPRSOH)))-sum($(=GetFieldSelections(MM_SOHMIN)))

Please, suggest me based on that..

Re: Need help in Pivot Table

krishna20 — Fri, 22 Jan 2016 06:18:45 GMT

Showing unconcerned values when using

=sum($(=GetFieldSelections(APPRSOH)))-sum($(=GetFieldSelections(MM_SOHMIN)))

Subtraction is not working correctly.PFA

Re: Need help in Pivot Table

PradeepReddy — Fri, 22 Jan 2016 06:41:32 GMT

you need to create 2 data islands as shown in previous post... and apply the bellow logic...

sum($(=GetFieldSelections(APPRSOH))-$(=GetFieldSelections(MM_SOHMIN)))

still if u are not getting wt you are expected, share sample application..

Re: Need help in Pivot Table

krishna20 — Fri, 22 Jan 2016 06:56:02 GMT

Hi Pradeep,

I have shared sample app in the start discussion of this thread . Please find it..

edit:

I cannot reload the application. I'm trying to achieve this in front end.

Re: Need help in Pivot Table

krishna20 — Fri, 22 Jan 2016 09:26:48 GMT

Any Idea to achieve this in front end or in back end friends?? Please help me out..