topic Re: calculated dimension pivot and straight table showing zero in QlikView

calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 10:54:26 GMT

Hi,

Below two calcluated dimensions i used in pivot and straight table. its showing first record acc name acc code starts with zero. i enabled supress when values is null in diemnsion tab but no use.

=if(ACNT_FLAG='C',ACNT_FLAG='M',ACNT_CODE)

=if(ACNT_FLAG='C',ACNT_FLAG='M',ACNT_NAME)

some one suggest some way to avoid it.

Thank you

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 10:56:18 GMT

Arul I don't completely understand what you are looking for, would you be able to share a sample or may be some screenshots to show what is going wrong?

Best,

Sunny

Re: calculated dimension pivot and straight table showing zero

MK_QSL — Tue, 23 Jun 2015 11:00:42 GMT

Try

=IF(ACNT_CODE = 'C' or ACNT_CODE = 'M',ACNT_CODE)

Re: calculated dimension pivot and straight table showing zero

jonathandienst — Tue, 23 Jun 2015 11:01:00 GMT

What is the expression supposed to achieve? If the first clause is true (ACNT_FLAG='C'), then it will return the second clause (ACNT_FLAG='M') which will always be false (0). I guess what you want is (in psuedo code)

if ACNT_FLG = 'C' or 'M' then ACNT_CODE else nothing

And in QV code

if(Match(ACNT_FLG, 'A', 'C'), ACNT_CODE)

Now suppress nulls should work

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:01:25 GMT

hi Sunny,

above calculated dimesion i used in straight table

plz check the image i am getting 0 value in acc code and acc name i want to avoid it

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:03:29 GMT

need to display both C and M records

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:04:57 GMT

Hi Manish bro,

it works but total value is wrong. i will upload sample app

Thanks

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:18:49 GMT

plz check this app in this table invidual record values are correct but total is incorrect

plz check opeing balance column in the straight table

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 11:21:09 GMT

Nothing shows up when I open the application.

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:23:24 GMT

app size is around 50 mb i reduced all data sunny

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 11:25:57 GMT

I guess if totals are the only thing that is incorrect, why don't you select this option:

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:32:03 GMT

no use sunny i am doing something wrong. first i thought it because of null values now it is not

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 11:32:25 GMT

thanks bro

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 12:06:10 GMT

Not sure how I may be able to help without any data in your application, but I am sure somebody else may be able to help you out

Best,

Sunny

Re: calculated dimension pivot and straight table showing zero

arulsettu — Tue, 23 Jun 2015 12:13:14 GMT

can you send your email to this arul.im4@gmail.com

so i will send with data app

Re: calculated dimension pivot and straight table showing zero

buzzy996 — Tue, 23 Jun 2015 12:21:08 GMT

sorry for interruption here,

Hi Sunny

is't simple to change display name ...if I'm not wrong..earlier ur's sunindia,later sunny T..now Sunny Talwar?...can u guide me on this..!

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 12:22:39 GMT

Guide you on what my friend?

Thanks for pointing that out though. I need to go back to sunindia

Re: calculated dimension pivot and straight table showing zero

MK_QSL — Tue, 23 Jun 2015 12:24:27 GMT

Re: calculated dimension pivot and straight table showing zero

buzzy996 — Tue, 23 Jun 2015 12:29:10 GMT

May I know how to change the display name on community ?

For example, I'm thing to change my second name,now my name is showing as Shiva Qlik.. I have to replace Qlik with some other word or i've to drop the second word from my name

Re: calculated dimension pivot and straight table showing zero

sunny_talwar — Tue, 23 Jun 2015 12:36:36 GMT

Keep yourself logged in and go to this website: Qlik Sense Desktop | Qlik

Fill in the new name you want to show and click Download Now. (this will download Qlik Sense which you can discard later), but that should update your name on the community .

Just a note: sunindia is my username and Sunny T is the name I want to be displayed, but somehow it keeps going back to my last name

I hope that will help