topic Re: Qlikview Pivot Chart with new dimension and expression in QlikView

Qlikview Pivot Chart with new dimension and expression

haribabugv — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to add a new row label to my existing pivot chart in Qlikview but I am not able to add any row label.

The expression for that row label is also a formula which I have attached in excel sheet.

Can you fix this .qvw table with Row label and formula as per the Sample excel sheet (Tab Name:Pivot)

Thanks

Hari Babu

Re: Qlikview Pivot Chart with new dimension and expression

sunny_talwar — Fri, 25 Aug 2017 13:35:34 GMT

May be like attached

Dimension

=Pick(Dim, [Data Type], 'New Row Label')

Date

Expression

Pick(Dim, Sum(Qty), Before(Sum({<[Data Type] = {'B', 'C'}>}Qty)) - Sum({<[Data Type] = {'A'}>}Qty))

Re: Qlikview Pivot Chart with new dimension and expression

haribabugv — Sat, 26 Aug 2017 10:10:08 GMT

Hello Sunny,

Based on your solution, i was trying to build a package around Pick function. I am facing problem when I am trying to pull a chart with pick dimensions.

so can you please check the sample excel sheet and qlikview file and let me know the right way to approach the graph built in excel sheet ?

Re: Qlikview Pivot Chart with new dimension and expression

sunny_talwar — Sat, 26 Aug 2017 11:27:41 GMT

Try attached

Re: Qlikview Pivot Chart with new dimension and expression

haribabugv — Sat, 26 Aug 2017 11:33:26 GMT

Your calculations are out of the box...

Thanks a lot

Re: Qlikview Pivot Chart with new dimension and expression

haribabugv — Sun, 27 Aug 2017 15:42:59 GMT

Hello Sunny,

I have built a straight table based on the logic you provided above.

This Column Inventory Min Cover is a calculated expression in the straight table.

Can you help me out if I can refer this highlighted yellow cell in text box?

I wanted to show this value (eg:22777) average of that column in a text box

Re: Qlikview Pivot Chart with new dimension and expression

sunny_talwar — Mon, 28 Aug 2017 01:03:54 GMT

Would you be able to share the file where you have this straight table?

Re: Qlikview Pivot Chart with new dimension and expression

haribabugv — Mon, 28 Aug 2017 02:50:56 GMT

Hi,

Please find the attached sample file where there are two charts , one with complete table and the other chart only with average value of one single column.

Is there any other way to show the second chart (preferably in Text box etc) where i am having single cell (average value of particular column)?

Re: Qlikview Pivot Chart with new dimension and expression

sunny_talwar — Mon, 28 Aug 2017 12:09:28 GMT

I don't think I have a way to resolve this unless you are willing to do this in the script... But the problem with script will be that it will be a static value which won't change based on selections. I know kush141087‌ worked on a similar issue, may be he can share his expertise

Re: Qlikview Pivot Chart with new dimension and expression

haribabugv — Mon, 28 Aug 2017 13:55:33 GMT

Thanks Sunny.

Yes it should be dynamic.

Hoping that kush141087‌ can solve my issue...