topic Re: Expression Help For Straight Table in QlikView

Expression Help For Straight Table

sona_sa — Tue, 05 Mar 2019 13:55:38 GMT

Hi Team,

I have a straight table, where, First 3 Column is my Dimension and another 6 is my Expression. Rolling three month calculation and then status and last one is Also some calculation.

Now in Column 7, 8 and 9 there is null or missing value are available. Now I want to remove or hide the same row from my straight table.

Output will be same as it is in excel. only want to remove or hide null or missing value rows from straight table.

can anyone help me on the same.

Please find the attached xls. for the same.

Please response, If it is possible with an example.

Thanks & Regards,

Re: Expression Help For Straight Table

bharathadde — Tue, 05 Mar 2019 18:05:07 GMT

Try applying this on dimensions which eliminates null values for Green, Amber and RAG

Workstream:
=if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),Workstream)
Ref:
=if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),Ref)
LOB:
=if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),LOB)

Re: Expression Help For Straight Table

sona_sa — Wed, 06 Mar 2019 05:52:46 GMT

Hi Bharat, Thanks for response. This is working fine for Green / Amber and RAG Expression, Where the null or missing value. But when the rolling month expression has null or missing value is available that time it is not working. I tried to make the code for the same but it is not performing. Code is below.

Workstream : =If((Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG]) or Not IsNull($(vCurrentMonthM0)) or Not IsNull($(vCurrentMonthM1))),[Workstream Calc Dim])

KPI : =If((Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG]) or Not IsNull($(vCurrentMonthM0))
or Not IsNull($(vCurrentMonthM1))),KPI)))

LOB : =If(Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG] or Not IsNull($(vCurrentMonthM0)) or Not IsNull($(vCurrentMonthM1))),[LOB Calc Dim])

Can you suggest or help me on this.

Regards,