Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dhanu_today
New Contributor III

Count layout

     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

19 Replies
senpradip007
Valued Contributor III

Re: Count layout

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.

dhanu_today
New Contributor III

Re: Count layout

Thanks Pradip.But not working...

senpradip007
Valued Contributor III

Re: Count layout

Can you post a sample application?

veidlburkhard
Contributor III

Re: Count layout

Hi dhanu,

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

Burkhard

Not applicable

Re: Count layout

Dhanu

write in expression - Label as

='>=50000 and <=100000'     and

='>100000  and <=150000'

Lalit

dhanu_today
New Contributor III

Re: Count layout

Burkhard-Am using Pivot table.

veidlburkhard
Contributor III

Re: Count layout

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

dhanu_today
New Contributor III

Re: Count layout

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

Dhanu

veidlburkhard
Contributor III

Re: Count layout

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

Burkhard