pivot table numbers

[#1]

Hi All,

I am facing issue. I have following tables: Date_Table & Account.

Both table has Eve_date column common. I am using Eve_Date ( Date Table) in dimension & Sum(Actual Efforts ) from Account table in pivot. It should show all the dates from Date Table. But it is not showing.

I have used supres 0 values. I have join both table with Left Keep, but still it is not showing expected output.

Please help.

[qlikview979]

Hi ,

Can you please share sample app

[Anil_Babu_Samineni]

If you feel to combine tables then use Where Exists Key word

Or , Go and use Qualify and Unqualify statements then count only for that dates. If not, You may check Data model preview whether data produced or not

[Anonymous]

You can send your qvw once. We can see how you are approaching.

[#5]

if I use where exist, it will combine the dates which are exist in both table which Qlikview does automatically when I use concat. I want all dates from Date Table weather it is exist or not exist in Account table.

[qlikview979]

may be

if you go for Concatenate it will give all dates

or

go for left join it will take all dates from first table ,matching dates from second table

or

please share the sample data

[Anil_Babu_Samineni]

Then go for Qualify and Un-Qualify Statements

[tyagishaila]

In Dimension Tab

Check Show All Values

[vinieme12]

uncheck Supress Zero values

"I have used supres 0 values"

[#10]

Hi All,

Thanks its solved but I have another issue.

I am using "NA" for 'Populate Missing value' in presentation tab. I want to format that values in pivot as a white text and fill. I mean if pivot cells has value "NA" then format it white background and font color.

Thanks'