Regarding Expression appearence in TOTAL Mode only

[sarfaraz_sheikh]

Dear All,

Is it possible in qlikview to show particular expression in Total mode only.

For example

Grade                         IT                CE                Mech              Co          

A              Sum         50                 70                  40                   80
                 %            2                   10                  15                 20

B              Sum         50                 70                  40                   80
                 %            2                   10                  15                 20

C              Sum         50                 70                  40                   80
                 %            2                   10                  15                 20

Total          Sum        150                210                120                160

                  %            6                    30                  45                 60

My question is that i want % expression to be show only in total ..not with all grades......like below

Grade                         IT                CE                Mech              Co          

A              Sum         50                 70                  40                   80
                 

B              Sum         50                 70                  40                   80
                 

C              Sum         50                 70                  40                   80
                

Total          Sum        150                210                120                160

                  %            6                    30                  45                 60

is it possible if yes then it would be more helful for me.

Sarfaraz

[#2]

Please find the attached document

[sarfaraz_sheikh]

Dear all,

Any clue or solution for above post would be much appreciated ....it is urgent

Sarfaraz

[sarfaraz_sheikh]

Dear Venket,

The % should show in TOTAL mode only not with grades... like below

Grade                         IT                CE                Mech              Co           

A              Sum         50                 70                  40                   80
                 

B              Sum         50                 70                  40                   80
               

C              Sum         50                 70                  40                   80
                 

Total          Sum        150                210                120                160

                  %            6                    30                  45                 60

is it possible

Sarfaraz

[timanshu]

Hi,

Do this For expression which you dont want to show totals :

if(isnull(Rowno()),null(),sum(MTD))

where sum(MTD) is actual expression. Replace null() with any value you want.

look for attached screenshot too.

[nagarjuna_kotha]

Hi Sarfaraj,

Use below expression.

Exp :

if (getselectedcouunt(Grade)=0,

Sum({<Region={'East'},Grade={'Total'}>}Value)

,

Sum({<Region={'East'},>}Value)

))

Regards,

Nagarjuna

[sarfaraz_sheikh]

Dear Timanshu,

I did not understand what you wrote .....I want to show the particaular expression in Total mode only

Can you please keep any example here for my understanding ..

Sarfaraz

[stabben23 · Accepted solution]

Hi, use

if(dimensionality()=0 ,"your expression"))

[timanshu]

Hi,

I misunderstood, Can you provide me the expression to calculate %  to help you out?

[sarfaraz_sheikh]

Dear Staffan,

thanks for your solution ..........I got as expected however i want to remove a label(Lead %)  also...only want to show in Total only ...

I tried the same logic but in case of label it does not working .....kindly help

Sarfaraz