Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Error in chart


Hi friends

I have data like this

Amount_Type Amount

A 800

B 800

B 800

B 900

C 800

I added caluculated Dimention like Amount_Type ='B' and Expression as Sum(Amount).

I am getting only -1 and 0 as Dimentions.

Thanks

Pavan

Tags (1)
1 Solution

Accepted Solutions
sujeetsingh
Honored Contributor III

Re: Error in chart

=if(Amount_Type = 'B', Amount_Type)

9 Replies
Not applicable

Re: Error in chart

I think the above function is giving you the result in boolean format

manideep78
Valued Contributor

Re: Error in chart

Hi Pavan,

Try like this in calculated dimension and check the suppress when value is null option

=if(Amount_Type = 'B', Amount_Type)

Regards,

Manideep

sujeetsingh
Honored Contributor III

Re: Error in chart

=if(Amount_Type = 'B', Amount_Type)

Re: Error in chart

Hi,

Write

wildmatch(Amount_Type,'B',Amount_Type) use this as your calculated Dimension.

And select Supress Null values in Dimension tab

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Error in chart

Hi,

have a look at attached application.

two approaches shown.

Regards

ASHFAQ

MVP
MVP

Re: Error in chart

Create a Straight Table

Dimension = Calculated Dimension

=Aggr(IF(Amount_Type = 'B',Amount_Type),Amount_Type)

Tick Suppress When Value is NULL

Expression

SUM(Amount)

Not applicable

Re: Error in chart

again its showing 1 and 2 values

Re: Error in chart

Hi,

Its my bad It is like

if(wildmatch(Amount_Type,'B'),Amount_Type)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

Re: Error in chart

have you checked my reply?