topic Re: Problem in QlikView

Problem

Tue, 05 Aug 2014 07:18:19 GMT

Is possible to generate above chart in below format using straight table

Re: Problem

er_mohit — Tue, 05 Aug 2014 07:22:12 GMT

yeah go to below link

Expression Total

Re: Problem

maxgro — Tue, 05 Aug 2014 07:28:56 GMT

if I understand your questiom try with dimension limit

Re: Problem

Tue, 05 Aug 2014 08:55:33 GMT

thanx masimmo,,but in my case it give wrong result means it correct summation

Re: Problem

Anonymous — Tue, 05 Aug 2014 08:59:11 GMT

Hi,

Post some sample data ......

Re: Problem

martynlloyd — Tue, 05 Aug 2014 09:05:42 GMT

Are some columns correct and some not?

Re: Problem

Tue, 05 Aug 2014 09:09:18 GMT

Is there is any to represent a chart in this format

Retail,F&B etc are the values of column Business.how we can display name of each field value in chart like retail total

As ,I am able to calculate the retail total and F&B total ,But how i can display name total or F&B total

see the attachment for the reference

I want to show advertisement total instead of Business total

Re: Problem

Anonymous — Tue, 05 Aug 2014 09:12:11 GMT

Hi Shweta,

This was possible in Pivot table,

In the properties of Pivot table properties,

Under presentation check on Show Partial Sums..

Re: Re: Problem

Anonymous — Tue, 05 Aug 2014 09:18:13 GMT

Re: Problem

Tue, 05 Aug 2014 09:27:10 GMT

Hey venkata

I have already implemented that using pivot

but my question is to display retail total,f&b total text which is the value of the column

Re: Re: Problem

Anonymous — Tue, 05 Aug 2014 09:34:15 GMT

I'm understand u r requirement .. can u elaborate it clearly ?

If possible post sample data

Re: Problem

qlikoqlik — Tue, 05 Aug 2014 10:12:43 GMT

Hi Shwetha

There is Lables for Totals in the pivot table

I can only work out on the selected value using the below expression

GetFieldSelections(Contract) & 'Total'

Thanks and regards

Padma

Re: Problem

Fri, 08 Aug 2014 08:37:54 GMT

IT WON'T WORK

Re: Problem

Anonymous — Fri, 08 Aug 2014 08:40:17 GMT

Place some sample data here

will post the application(QVW)

Re: Problem

simondachstr — Fri, 08 Aug 2014 08:52:11 GMT

Use the dimensionality() function in combination with Padma's expression.

Re: Problem

Fri, 08 Aug 2014 08:53:42 GMT

HOW

Re: Re: Problem

Fri, 08 Aug 2014 08:54:33 GMT

PFA

Re: Re: Problem

Fri, 08 Aug 2014 10:04:12 GMT

=if(Dimensionality()=1,GetFieldSelections([Sub category]))&'Total'

I used this exp but it won't work

Re: Re: Problem

simondachstr — Fri, 08 Aug 2014 10:26:00 GMT

Use Only() instead of GetFieldSelections

Re: Re: Re: Problem

Sun, 10 Aug 2014 15:34:30 GMT

I used this

=if(Dimensionality()=1,Only(business))&'Total'

but it won't work. see the attachment