topic Re: Constant Values in Pivot Chart in QlikView

Constant Values in Pivot Chart

Wed, 01 May 2013 16:51:11 GMT

Hi,

Could anybody tell me how can i show a constant value in the pivot table expression..

I want to get a Constant value for all rows in the Pivot Table. The value should be maximum of the Unload Qunatity.

Here i am attaching a Image, in this i want to get the value 25182 for all the location AZ..

Thanks

Renjith kumaran

shree909 — Wed, 01 May 2013 16:57:01 GMT

Hi if ur using the set analysis use 1 u will get all the values irrespective of selections.

$ will give current selections

sum({1<date= {'04/39/2013'} >}sales)

or else put a sample file it will be easy to figure it out..

Thanks

Wed, 01 May 2013 17:01:40 GMT

Shree,

i dont need the data based on date. It will be a bit difficult to publish the file as its a live file of my client. I will try to add a dummy one.

I just need to show the constant value there.

Thanks

Renjith Kumaran

Thu, 02 May 2013 17:21:01 GMT

Anybody?

Please advice me to find a way..

Thanks

Renjith Kumaran