Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to create static dimension in qlikview.....I want to show the 0 values column in my pivot table ...However whenever i checked on suppress when value is null then 0 values column will also get hide.
Can anybody help me with this...i.e. how i can acheive this requirement...how i can add 0 for null column's in pivot table.
Please have look on below scenario for more clarity of problem....
When All Status_Description Selected:
Ergo_Loc TotalLeads_Considered Follow_Up Insurer_reject Sales_closed_final
Chennai Amount 197457 11848 - 177247
count 28 2 - 25
Mumbai Amount 135475 5439 - 104281
count 20 1 - 16
- Amount 135475 5439 - 104281
count 20 1 - 16
When I Click on Suppress When Value is null on Ergo_Loc Tab then It's look like below.
Ergo_Loc TotalLeads_Considered Follow_Up Sales_closed_final
Chennai Amount 197457 11848 177247
count 28 2 25
Mumbai Amount 135475 5439 104281
count 20 1 16
My Actual Requirement is :
Ergo_Loc TotalLeads_Considered Follow_Up Insurer_reject Sales_closed_final
Chennai Amount 197457 11848 0 177247
count 28 2 0 25
Mumbai Amount 135475 5439 0 104281
count 20 1 0 16
Sarfaraz
Dear gwassenaar jagan ......please answer i am very much stuck in this problem
Duplicate of How to create static dimension in pivot table. I have locked this thread, please refer to the other thread.