
Contributor III
2024-08-07
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Instead of "-" I want "0" in my Pivot Table
I have a Pivot Table in that table Row I have category in Column we have Sub Category and in Values I have Sales in my pivot table wherever there is "-" I want "0" in Qliksense
Labels (10)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
dimension
-
expression
-
filter
-
Qlik Cloud
-
Qlik Sense
-
Script
-
Variables
-
Visualization
4 Replies

MVP
2024-08-07
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@BhaminiParmar12 what is the measure ?
463 Views

Contributor III
2024-08-07
07:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Kushal_Chawda Measure is Sales
Below is my Script
LOAD
Category,
Sales,
Profit,
"Sub-Category"
FROM [lib://Bhamini:DataFiles/ Task - instead 0.xlsx]
(ooxml, embedded labels, table is Sheet1);
456 Views

Contributor III
2024-08-07
07:44 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Kushal_Chawda as you can see in my Pivot Table There is "-" But I want 0
where ever there is "-"
453 Views

MVP
2024-08-07
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@BhaminiParmar12 It's because you don't have sales for all combination of Category and Sub Category, you need to generate and add missing combination of Category and Sub category to convert NULL to 0. See the attached
442 Views
