topic Re: Dimension Format in QlikView

Dimension Format

sona_sa — Fri, 14 Nov 2014 05:50:29 GMT

Hello Team,

I have a Profit & Loss qvw application, There is two Pivot Table. 1st One without YearMonth dimension, That Format is correct. Means

ADMINISTRATIVE & SELLING EXPENSES

TOTAL ADMINISTRATIVE & SELLING EXPENSES

Advances Recoverable In Cash Or In Kind For The Value To Be Received

Total Advances Recoverable In Cash Or In Kind For The Value To Be Received

Total

All these are in bold and Value is also in bold. But in 2nd Pivot I am using one more dimension, i.e is YearMonth. But when I am using 2nd dimension then my format is changed. But I need same format which is 1st One.

For more reference please find the attached QVW.

Thanks.

Re: Dimension Format

SergeyMak — Fri, 14 Nov 2014 06:53:05 GMT

Hi,

I see that by some reasons you don't have 'c' value for all of the Year-Month, that's why Only([Exec P&L Heading ]) will give you Null(), but not 'c'. You can reach the goal if you rebuild a data model a bit, It's a bit strange from my point of view.

Regards,
Sergey

PFA to see what I've found

Re: Dimension Format

sona_sa — Fri, 14 Nov 2014 08:26:15 GMT

Hi,

Is there any another option. Or also please let me know what type of changes I have to do in data model.

Thanks for reply.

Re: Dimension Format

sujeetsingh — Fri, 14 Nov 2014 08:54:21 GMT

I recommend you to use a small trick if the number of the headings is fixed\static use transparent text boxes with the same labels

Re: Dimension Format

sona_sa — Fri, 14 Nov 2014 09:12:49 GMT

I also tried by :

=If(([P&L Heading]='Assets' or

[P&L Heading]='Current Assets'or

[P&L Heading]='Cash and Cash Equivalents' or

[P&L Heading]='Total Cash and Cash Equivalents') and [P&L Calculation] = 'c','<B>')

But no any effect.

Thanks.

Re: Re: Dimension Format

SergeyMak — Fri, 14 Nov 2014 09:14:06 GMT

To be honest, you have pretty strange P&L, because you have only Expenses in some month

ADMINISTRATIVE & SELLING EXPENSES

LOSS DUE TO THEFT

PRIOR PERIOD EXPENSES

REGISTRAR & TRANSFER EXPENSES

SUNDRY BALANCE (W.OFF)

TOTAL ADMINISTRATIVE & SELLING EXPENSES

And

these type of transactions in other months

Advances Recoverable In Cash Or In Kind For The Value To Be Received

Advance (For Exp.)

Checks Received Clearing

Travelling Advance (Saumil Munshi)

Travelling Advance

Total Advances Recoverable In Cash Or In Kind For The Value To Be Received

And I didn't find any month where they are together...

How it's possible?

I see that you formatting is working fine if you select one month or several moth but with only First or Only second type of transactions.

Probably you've got this after

IntervalMatch:
INTERVALMATCH ([Reporting Code]) LOAD
ExecPLStart,
ExecPLEnd
RESIDENT ExecProfitLoss;

It's unclear for me, why did you do it..

I optimised a data model, but it didn't solve the main issue

PFA

Re: Re: Re: Dimension Format

sona_sa — Fri, 14 Nov 2014 09:55:01 GMT

Thanks for reply Sergey.

I used the same. But there is one more problem and still the main output is also not coming. In YearMonth there is one more null colum is coming.

Please revert for any clarification. Also on the selection of Yearmonth it is not coming.

Thanks

Re: Re: Dimension Format

sona_sa — Fri, 14 Nov 2014 11:42:32 GMT

Hello

Any Hope for the same.

Thanks.