topic Re: UI Challenge in QlikView

UI Challenge

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

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

Re: UI Challenge

prma7799 — Thu, 15 Jun 2017 11:14:39 GMT

Please share sample app.

Re: UI Challenge

sunny_talwar — Thu, 15 Jun 2017 11:14:52 GMT

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

Re: UI Challenge

Sergey_Shuklin — Thu, 15 Jun 2017 11:20:10 GMT

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.

Re: UI Challenge

mhmmd_srf — Thu, 15 Jun 2017 11:34:35 GMT

Hello PM,

I am sharing the App.

Thanks,
Sarif

Re: UI Challenge

Anil_Babu_Samineni — Thu, 15 Jun 2017 11:45:15 GMT

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

Re: UI Challenge

prma7799 — Thu, 15 Jun 2017 12:00:02 GMT

Like this???

Re: UI Challenge

mhmmd_srf — Thu, 15 Jun 2017 12:21:51 GMT

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

Re: UI Challenge

prma7799 — Thu, 15 Jun 2017 12:30:58 GMT

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

Re: UI Challenge

mhmmd_srf — Thu, 15 Jun 2017 12:51:32 GMT

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