topic Re: Issue with If -Statement?? in QlikView

Issue with If -Statement??

priyav24 — Thu, 11 Jul 2013 09:04:35 GMT

Hello Everybody,

I have a requirement only account type 1 and 2 should be shown,Rest should not be shown in a pivot table..

I have tryed using the calculated dimension

"=if(AccountTypeCode=1 ,

if(AccountTypeCode=2 ,AccountTypeName))" This is not working,

So i have used an alternative calculated Dimension

"if(AccountTypeCode<>3 ,

if(AccountTypeCode<>4 ,AccountTypeName))"

Since we have only four account type this alternative method works ,If we had more account type then it will be very diffcult, I have attached qlikview file for the reference...

Is there any solution ??

Also i want to know how to customize style in pivot table.

Thanks in Advance,

Priya

Re: Issue with If -Statement??

kaushiknsolanki — Thu, 11 Jul 2013 09:09:18 GMT

Hi,

Try this.

If(Match(AccountTypeCode,1,2),AccountTypeName)

Regards,

Kaushik Solanki

Re: Issue with If -Statement??

swuehl — Thu, 11 Jul 2013 09:10:12 GMT

Don't use nested if() statement here, use something like

=if(AccountTypeCode=1 or AccountTypeCode=2, AccountTypeName)

Re: Issue with If -Statement??

er_mohit — Thu, 11 Jul 2013 09:10:40 GMT

try this

=aggr(only({$<AccountTypeCode={'1','2'}>}AccountTypeName),AccountTypeCode)

=aggr(only({$<AccountTypeCode={1,2}>}AccountTypeName),AccountTypeCode)

Re: Issue with If -Statement??

kaushiknsolanki — Thu, 11 Jul 2013 09:10:58 GMT

Another way is you use the set analysis.

Sum({<AccountTypeCode = {1,2}>}[Sum(VoucherAmount)])

Regards,

Kaushik Solanki

Re: Issue with If -Statement??

priyav24 — Thu, 11 Jul 2013 09:18:55 GMT

Thank you Kaushik..

Also I wanted to know how to customize the style in pivot table..

Re: Issue with If -Statement??

kaushiknsolanki — Thu, 11 Jul 2013 09:21:19 GMT

Hi,

You need to enable the setting under

User Preference -> Design -> Allow Show Design Menu Items.

Once you have enabled this.

Right click on the chart you will find an option called custom format cell.

Regards,

Kaushik Solanki

Re: Issue with If -Statement??

priyav24 — Thu, 11 Jul 2013 09:31:08 GMT

Thanks kaushik