topic Re: Count layout in QlikView

Count layout

dhanu_today — Tue, 18 Mar 2014 06:51:21 GMT

Hi All,

I have the data in my table as a result of an expression.How we can get the below bolded format in design level.

Segement(DIM1) Sub-seg(DIM2) Exp1 >=50000 and <=100000 >100000 and <=150000

TC TC-Azc 90000 1 -
TC TC-Apc 150000 - 1

TC TC-BCP 100000 1 -

TC TC-BCL 150000 - 1

Total :490000 2 2

The Sub-seg field is not required in table level as a dimension.So then

Segement(DIM1) Exp1 >=50000 and <=100000 >100000 and <=150000

TC 490000 2 2

Thanks in advance,

Dhanu

Re: Count layout

senpradip007 — Tue, 18 Mar 2014 06:57:35 GMT

Hi.

As you dont want to show Sub-seg(DIM2), go to presentation tab and choose the Hide Column and for the next two expressions in Presentation tab select respecpective expressions and write in Column Label

>=50000 and <=100000 and >100000 and <=150000 respectively.

Re: Count layout

dhanu_today — Tue, 18 Mar 2014 07:15:26 GMT

Thanks Pradip.But not working...

Re: Count layout

senpradip007 — Tue, 18 Mar 2014 07:31:36 GMT

Can you post a sample application?

Re: Count layout

veidlburkhard — Tue, 18 Mar 2014 08:00:09 GMT

Hi dhanu,

only one question. Are you using a pivot table or a straight table?

Burkhard

Re: Count layout

Tue, 18 Mar 2014 08:05:17 GMT

Dhanu

write in expression - Label as

='>=50000 and <=100000' and

='>100000 and <=150000'

Lalit

Re: Count layout

dhanu_today — Tue, 18 Mar 2014 08:44:18 GMT

Burkhard-Am using Pivot table.

Re: Count layout

veidlburkhard — Tue, 18 Mar 2014 08:51:55 GMT

OK dhanu,

then there is a simple solution.

Don't mark the 'Always Fully Expanded' check box in the 'Presentation' tab and collapse Sub-seg(DIM2) dimension.

That's all.

Hope this helps

Burkhard

Re: Count layout

dhanu_today — Tue, 18 Mar 2014 09:06:03 GMT

Thanks Burkhard...But still no luck...

Dhanu

Re: Count layout

veidlburkhard — Tue, 18 Mar 2014 09:18:24 GMT

Then, dhanu, you should attach your qvw ... otherwise no chance.

Burkhard

Re: Count layout

Tue, 18 Mar 2014 09:28:23 GMT

Dear Dhanu

Go to
settings->User Preference->Design

in design tab, there is a check box 'Always Show Design Menu Items'
Make it selected.press ok.

Now go to your pivot table, right click on it u will see the option 'Custom Format Cell' click it.
Now small window will appear. select >=50000 or select expression header you have and click on Bold check box.
Press Ok

Now you will see the expression header in Bolded format.

Lalit

Re: Count layout

dhanu_today — Tue, 18 Mar 2014 09:44:44 GMT

Thanks Lalit...But am looking for result of bolded columns not about the format like bold.

Dhanu

Re: Count layout

Tue, 18 Mar 2014 09:50:15 GMT

Either you can use CLASS function at chart level or you can actually create this differentiation at script level itself.

Thanks,

Angad

Re: Count layout

Tue, 18 Mar 2014 09:52:08 GMT

If you want entire column result in bold, then

in expression tab, expand expression by pressing +

There is 'text format'. In definition of it, write ='<B>'

This will lead entire column in bold

Re: Count layout

PrashantSangle — Tue, 18 Mar 2014 10:05:19 GMT

Hi,

If you want bold your label then in pivot table you can achieve this by

go to

Properties->visual Cues->select expression->Text ->In front you can see several check boxes like bold, underline,italic

Select appropriate check box

Regards,

Re: Re: Count layout

dhanu_today — Wed, 19 Mar 2014 12:35:18 GMT

Hi Can i get the same result in Pivot table with the removing of Code field as a dimension.

Thanks ,

Dhanu

Re: Re: Re: Count layout

PrashantSangle — Wed, 19 Mar 2014 12:45:44 GMT

Hi,

Yes you can do this only in Pivot table not in straight table.

check enclosed file

Regards,

Re: Count layout

dhanu_today — Wed, 19 Mar 2014 12:57:26 GMT

Thanks....But i want to show the count of these 2 expressions also.

(column(2)>=4000 and column(2)<6000,1)

(column(2)>6000 and column(2)<8000,1) Thats the problem.

Here we are showing the count on sum(Amount) which is wrong.

Let me know if you required any clarification.

Dhanu

Re: Count layout

dhanu_today — Wed, 19 Mar 2014 13:44:48 GMT

Any hint from anyone how it to get the same.Its a little bit urgent.

Thanks,

Dhanu

Re: Re: Count layout

PrashantSangle — Thu, 20 Mar 2014 06:23:19 GMT

Hi,

I am not sure this will help you or not but I made some changes in Pivot table in your given example.

Check that hope it solve your problem.

Check enclosed file

Regards,