topic Re: Breaks between databases in QlikView

Breaks between databases

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Breaks between databases

sasiparupudi1 — Wed, 09 Aug 2017 15:51:06 GMT

Please provide sample app

Re: Breaks between databases

passionate — Wed, 09 Aug 2017 16:02:55 GMT

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

Re: Breaks between databases

mparker123 — Wed, 09 Aug 2017 16:35:06 GMT

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

Re: Breaks between databases

passionate — Wed, 09 Aug 2017 17:02:14 GMT

Hi Matt,

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

Sorry But, i didn't get your requirement.

Regards,

Pankaj

Re: Breaks between databases

mparker123 — Wed, 09 Aug 2017 17:25:36 GMT

WO and MJG

Re: Breaks between databases

mparker123 — Wed, 09 Aug 2017 17:37:39 GMT

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

Re: Breaks between databases

kaushiknsolanki — Wed, 09 Aug 2017 17:44:00 GMT

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

Re: Breaks between databases

mparker123 — Thu, 10 Aug 2017 14:41:38 GMT

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.