Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to avoid exta bar graphs?How to do it?please give me the suggestions

Hi All,

I want to delete or avoid the unwanted bars in below graph highlighted Black.

Regards,

Karthik

22 Replies
PrashantSangle

Hi,

Go to dimension tab->select Supress null.

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 🙂
pokassov
Specialist
Specialist

Hi!

14.png

Not applicable
Author

Go to dimension tab and Select Dimension and tick Suppress When Value Is Null Check box.

Not applicable
Author

Hi,

Thank you very much for the quick response. I have got it.

Hava a good day.

Regards,

Karthik

Not applicable
Author

Hi ,

I need to remove the synthetic key in the table.

Can you suggest the requested script to remove the synthetic key.

Regards,

Karthik

PrashantSangle

Hi,

Create key

like

field1&'-'&field2 as key

and rename both fields in table

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 🙂
Anonymous
Not applicable
Author

Another way to remove the synthetic key would be rename the field ( aliasing ) or use qualify all and unqualify statement before the table name and keep only the field which has to join ( unqualified ).

Best Regards,

Shubham

Not applicable
Author

Hi,

Please find attached files and please let us know how to delete the synthetic keys.

1.PNG

Regards,

Karthik

PrashantSangle

Hi,

Just Rename 3 Field from Fact Deposits and Fact Loan Table

Age,

Principle Amount,

Expenses

and

Keep Account Id so that it will create association between above two tables

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 🙂