UI Challenge

[mhmmd_srf]

Hi All,

I have one required UI like this:

And I am able to make like this:

I have used One container with in that three Pivot Table.

Three Things are pending:

1. Need to have the Level Total Units, instead of Total in the second Pivot Table.

2. Need to have level Units per Hour in the third Pivot table.

3. Total Hours level should be bold in first Pivot table.

Please any one help me on this.

Thanks a lot in advance for all your help.

Thanks,

Sarif

[prma7799]

Please share sample app.

[sunny_talwar]

It might take some time to configure this, but your issue can be resolved like How to Create a Profit and Loss Statement in QlikView

[Sergey_Shuklin]

Hello, Mohammad!

1. There is a "Label on Totals" on Presentation tab;

2. You should try a horizontal straight table or make the second expression equal 0 and hide it somehow;

3. If Total Hours is the separate expression look into the Text Format option in expression tab. If it's a dimension - try to do the same on dimension tab.

[mhmmd_srf]

Hello PM,

I am sharing the App.

Thanks,
Sarif

[Anil_Babu_Samineni]

I like challenges in UI

May be this?

1) Go to properties - Visual Cues - Select Expression - Make it as bold

2) Can you explain little more

3) Go to properties - Presentation - Use Label for Totals as you need

[prma7799]

Like this???

[mhmmd_srf]

Yes..close to my requirement ...

Only in third Pivot table, I want a Level, called Units per Hour.

How you make the Numbers in bold in 1st Pivot table?

Please help.

Thanks,

Sarif

[prma7799]

Like this ??

How you make the Numbers in bold in 1st Pivot table?

Ans:  Go to > View > Design Grid > Then Right click the object > Custom Format Cell

Note: we need to put cursor over the dimension or expression or which area you want to format

[mhmmd_srf]

Thanks a lot PM..

I learned many things from you..

One small thing..

I need the Units Per Hour in place of 61.1. The we don't want to show over all value.

Thanks,

Sarif