Breaks between databases

[mparker123]

Hello All,

I am building out a straight table, and want to show the breaks in the data. We use a tracking system to tack employee HOURS. I want the straight table to display values when an employee forgets to enter in HOURS for the day

   Dimension Tab:                                     Expressions Tab:                                                      

   If(HOURS='0', Lan_ID)                          If(HOURS='0',Day_Number)

                                                                 If(HOURS='0',Month)

                                                                 If(HOURS='0',YEAR)

The problem with these expressions is that data is showing when it shouldn't. The way the tracking system is set up, list projects and you fill in hours for those projects. If you don't work on a particular project that project will be zero. So my Day will say I worked 8 hours but a project may say 0. I want to show the breaks when the total day hours = 0

[sasiparupudi1]

Please provide sample app

[passionate]

Hi Matt,

try this:

   Dimension Tab:                                     Expressions Tab:                                                         

   If(HOURS='0', Lan_ID,Null())                          If(HOURS='0',Day_Number,Null())

                                                                 If(HOURS='0',Month,Null())

                                                                 If(HOURS='0',YEAR,Null())

then suppress null in dimension tab.

Please let us know if this work.

Regards,

Pankaj

[mparker123]

No it did not work Pankaj, do you have any other suggestions? i attached a mock up

[passionate]

Hi Matt,

Which Lan_Id you don't want to show in straight table.

Sorry But, i didn't get your requirement.

Regards,

Pankaj

[mparker123]

WO and MJG

[mparker123]

SB and TW should also be removed. It should just be JH and GB

[kaushiknsolanki]

Hi Matt,

If you look at the WO and MJG their Hour is 0. So the chart is working as per your expression.

On what basis you want to remove them.

Regards,

Kaushik Solanki

[mparker123]

I updated the QlikView to show you what i mean. In the BLUE text objects it will explain what I am talking about and what I am seeing. For July 28 WO posted 8 hours of vacation but the activity descriptions are different, same projects but different activity descriptions.