Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

help me in writing expression?

Hi All,

I have field billing

billing

accounts

payment

tenders

dues section

fines section

I am using billing field as dimenstion, now i dont want to display tenders and dues section columns in my chart?

Can anyone please help me ASAP.

Thanks,

Durga

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Honored Contributor III

Re: help me in writing expression?

Load * Inline [

billing,payment

tenders,100

dues section,200

aaa,50

bbb,60 ];

In Chart,

Calculated dimension: =Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)

Expr: sum(payment)

Check "Suppress When Value is NUll" in chart

740321.png

View solution in original post

29 Replies
Highlighted
Honored Contributor II

Re: help me in writing expression?

hi,

In your dimension> edit the dimension

if( Billing =  'tenders' or Billing = 'dues section' , null(),billing)

Check the option for hide null values.

HTH

sushil

Highlighted
Not applicable

Re: help me in writing expression?

Hi Durga,

Just you remove those fields from  your chart(dimensions)

Priyantha.

Highlighted
Contributor III

Re: help me in writing expression?

Sushil not getting any changes to chart after giving condition. i used suppress when values is null also.

Durga

Highlighted
Contributor III

Re: help me in writing expression?

how to remove field in edit script without going to source data.

Durga

Highlighted
MVP
MVP

Re: help me in writing expression?

Hi

Use this for the calc dimension:

=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Honored Contributor II

Re: help me in writing expression?

can you share your sample app ?

Highlighted
Honored Contributor III

Re: help me in writing expression?

In script,

Load * From Table

Where Not (Billing =  'tenders' or Billing = 'dues section');

Highlighted
Contributor III

Re: help me in writing expression?

it showing syntax error under { besided 'tenders. I cross checked, everything i kept fine. but showing error.


Highlighted
Honored Contributor III

Re: help me in writing expression?

It's not syntax error. Red marks are due to minus used in Set analysis

=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)