topic Re: cal in QlikView

cal

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

HI All,

This are my expression now i want to bring this as a dimension..

Can somoene please suggest my how to bring this expression into Calculted DImension ?

=Count({<Env={'AB'}>}if([Status z='Pass',0))

Count({<Env={'AB'}>}RunNumber)

count(Cost)

Thanks in Advance

Re: cal

devarasu07 — Mon, 18 Sep 2017 06:13:01 GMT

Hi,

Try like this

=aggr(Count({<Env={'AB'}>}if([Status z='Pass',0)),RunNumber)

In general,

Aggr( <here write your calculated expression >), your dimension)

https://www.analyticsvidhya.com/blog/2014/02/aggr/

Thanks

Deva

Re: cal

smilingjohn — Mon, 18 Sep 2017 06:34:30 GMT

Thanks for the Reply Deva

This is showing different result ..

Is there any ither way to write the calculted dimenion ?

Becuase the numbers are repeating ( Duplicating )

Re: cal

devarasu07 — Mon, 18 Sep 2017 06:49:26 GMT

Hi,

It should work, can you share you app or screen shot? Tks

Regards,

Deva

Re: cal

dinuwanbr — Mon, 18 Sep 2017 06:55:37 GMT

Hi Roy,

Can you upload a sample here?

Rgds,

Tharindu

Re: cal

smilingjohn — Mon, 18 Sep 2017 07:18:39 GMT

Hi Devarsu,

Please find the attachment of the QVW file.

I have two charts first is the Expression based and second one is the Calculated Dimension.

I wante to remove the duplicates from Expression charts ..therefore tried to get that into Calculated dimension .

But this is not wrking..

Thanks

Re: cal

smilingjohn — Mon, 18 Sep 2017 07:19:42 GMT

Hi Tharindu..

I have uploaded the sample ..

I need to remove the duplicates ...which are repeating

Thanks

Re: cal

dinuwanbr — Mon, 18 Sep 2017 07:36:39 GMT

Dear John,

Basically What I found is your Data Model is wrong. Severity is in another table which is linked through Release Number and you are taking a count of RunNumber which is in another table. So obviously its duplicating. Try to do any applymap() or something to get necessary data from that table into second table.

Check the attached file here. Sheet no 2.

Rgds,

Tharindu

Re: cal

smilingjohn — Mon, 18 Sep 2017 08:34:08 GMT

Hi Tharindu ,

Can you please show me how do we Apply map ..

I have added the script

Please find the attachment

Re: cal

dinuwanbr — Mon, 18 Sep 2017 08:52:03 GMT

Hi Roy,

Applymap has to be done in script level

Mapping_Severity:

mapping

Load

Rls,

Severity

from (The file for JIRA);

then while loading

ALM_TC_RUN:

load

...

Applymap('Mapping_Severity',Severity) as Severity

from (file for Alm_TC_RUN);

if u are loading JIRA file then comment severity field.

For More Please check followings

quick applymap example

Joins and Lookups

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Apply Map

Rgds,

Tharindu

Re: cal

dinuwanbr — Mon, 18 Sep 2017 08:58:08 GMT

Hi Roy,

PFA

Rgds,

Tharindu

Re: cal

smilingjohn — Mon, 18 Sep 2017 09:46:57 GMT

HI Tharindu

I applied your suggested changes and reloaded the script but i dont see ny changes

Re: cal

dinuwanbr — Mon, 18 Sep 2017 10:17:52 GMT

Dear Roy,

Can you tell How many Severity for one Release Number?

Re: cal

smilingjohn — Mon, 18 Sep 2017 11:15:44 GMT

Hi Tharindu

There will 4 severity ...And I cannot comment severity from Jira table as we need this field in other reports also..