topic Re: Regarding Expression appearence in TOTAL Mode only in QlikView

Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 06:50:02 GMT

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

Re: Regarding Expression appearence in TOTAL Mode only

Tue, 07 Apr 2015 07:12:45 GMT

Please find the attached document

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 07:13:51 GMT

Dear all,

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

Sarfaraz

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 07:18:07 GMT

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

Re: Regarding Expression appearence in TOTAL Mode only

timanshu — Tue, 07 Apr 2015 07:27:55 GMT

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.

Re: Regarding Expression appearence in TOTAL Mode only

nagarjuna_kotha — Tue, 07 Apr 2015 07:32:23 GMT

Hi Sarfaraj,

Use below expression.

Exp :

if (getselectedcouunt(Grade)=0,

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

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

))

Regards,

Nagarjuna

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 07:33:51 GMT

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

Re: Regarding Expression appearence in TOTAL Mode only

stabben23 — Tue, 07 Apr 2015 08:12:03 GMT

Hi, use

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

Re: Regarding Expression appearence in TOTAL Mode only

timanshu — Tue, 07 Apr 2015 08:41:22 GMT

Hi,

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

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 10:43:22 GMT

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

Re: Regarding Expression appearence in TOTAL Mode only

stabben23 — Tue, 07 Apr 2015 10:55:45 GMT

Hi,

for ex. in textcolor in your expression make it white, like if(dimensionality()=2,White())

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 11:04:02 GMT

Dear Staffan,

Brilliant ..........Your solution is working as expected..However can you please explain what is Dimensionality() in details.

Sarfaraz

Re: Regarding Expression appearence in TOTAL Mode only

stabben23 — Tue, 07 Apr 2015 11:08:27 GMT

Hi,

Dimensionality is different levels in your pivot. Just add dimensionality() as expression and you can see all levels like 0,1,2,3.. where 0 alway is your Totalrow.

Re: Regarding Expression appearence in TOTAL Mode only

sarfaraz_sheikh — Tue, 07 Apr 2015 11:20:55 GMT

Dear Staffan,

Thanks for your help ....really appreaciable ......have great year ahead...

Sarfaraz