Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
sujeetsingh
Master III
Master III

=if(Amount_Type = 'B', Amount_Type)

View solution in original post

9 Replies
Not applicable
Author

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

manideep78
Partner - Specialist
Partner - Specialist

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
Master III
Master III

=if(Amount_Type = 'B', Amount_Type)

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ashfaq_haseeb
Champion III
Champion III

Hi,

have a look at attached application.

two approaches shown.

Regards

ASHFAQ

MK_QSL
MVP
MVP

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
Author

again its showing 1 and 2 values

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

have you checked my reply?