topic Re: How to get the Count Expression for Total available number? in QlikView

How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:21:36 GMT

Hello Community,

I am new to Qlik View. I am trying to get the total available number for VC configuration.

But i am not getting the Expreesion...

Example:

I am having toatal num of available sales documents for VC is 2340, with in this 2340 docs VC is available for 2000 sales docs and VC is not availbe for 340 s docs.

So i am trying to get the Total no.of available VC s.docs(2000)...

Please help me on this how to write the Expression for it.

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:24:20 GMT

You can simply create a flag for which ever record VC is available and use that in your expression like below.

SUM({<VCAvailableFieldFlag = {"1"}>} Sales)

Hope this helps.

Aadil

Re: How to get the Count Expression for Total available number?

Mon, 08 Dec 2014 12:24:49 GMT

Hi Kottala Bhupal,

Plz ellaborate ur fields and also hw u get 2000 as available n 340 as not available.

Regards,

kukzzz....

Re: How to get the Count Expression for Total available number?

anbu1984 — Mon, 08 Dec 2014 12:25:48 GMT

=Count(Total VC)

Re: How to get the Count Expression for Total available number?

simenkg — Mon, 08 Dec 2014 12:26:51 GMT

Count({<VC={*}>} [Sales Documents])

If you create a flag in your load script that checks if VC is availible you can use that to filter the expression.

Load *,

if(isnull(VC),1,0) as IsVC

from table....;

count({<IsVC={1}>} [Sales Documents])

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:38:33 GMT

Hi Aadi,

Can you please let me know how to create a Flag for the records VC is available..

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:45:02 GMT

Hi Simen Kind,

I did not created any flag in the script as of now.

Can you please let me know how to create the fleg for YES or NO..?

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:49:47 GMT

Based on your description, considering you have a table where VC detail is available and document names are also there in some field.

in the script

LOAD
VCFieldName,

IF(Len(VCDocumentField) > 0, 1) as VCAvaialbleFieldFlag

FROM *....

Hope this helps.

Aadil

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:50:09 GMT

Hi Anbu,

I have writen expression for total VC number.

I need to get the Total availabel VC for sales documents.

for supose VC availbe num is 8 from total VC number.

So i would like to show

Total availabe VC Total not availbe VC

8 2

Please let me know how to write the flag for it and how to use the flag for the same.

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

simenkg — Mon, 08 Dec 2014 12:50:26 GMT

if VC has the value Yes or No, then you already have a flag of sorts.

You could make it into a 1,0 flag by writing in your loadscript:

Load *,

if(VC='YES',1,0) as VCFlag

from table;

Count({<VC={'YES'}>} [Sales Documents])

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 12:56:55 GMT

Hi Aadi,

i am using Inline table.

But i have the field VC BOM with the values YES or NO.

In this situation how can i cretae the Flag?

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 13:06:04 GMT

Hi Anbu,

I do not able to get this document.

Thanks for healping me..

Bhupal

Re: Re: How to get the Count Expression for Total available number?

anbu1984 — Mon, 08 Dec 2014 13:08:14 GMT

='Available:' &Count(VC)

='Not Available:' &Count(If(IsNull(VC),1))

Re: How to get the Count Expression for Total available number?

anbu1984 — Mon, 08 Dec 2014 13:11:44 GMT

Set Nullinterpret='';

Load * Inline [

SalesDoc,VC

2,aa

3,bb

5,dd

6,ad

7,dd

8,dfd

9,aaa

10,adf ];

='Available:' &Count(VC)

='Not Available:' &Count(If(IsNull(VC),1))

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 13:35:23 GMT

Hi Simen,

I am using Inline table in this requirement...

so how can i create the flag for it...

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

simenkg — Mon, 08 Dec 2014 13:39:14 GMT

Table:

Load *,

if(VC='YES',1,0) as VCFlag

inline [

Sales Document, VC

1, YES

2, NO

3, YES

4, YES

5, NO

];

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 14:03:28 GMT

Hi All,

I got the solution..

Thank you very much for healping me..

Best Regards

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Mon, 08 Dec 2014 14:10:23 GMT

Hi Simen,

I got the solution.

Thanks for healping me.

Bhupal

Re: How to get the Count Expression for Total available number?

Anonymous — Wed, 10 Dec 2014 06:00:52 GMT

Hi Simen,

i would like to get the subtraction between two values like 14-9=5

and multiply the 5 with 9(5*9)= 45.

Could you please help on this how to write the expression for these two queries.

my table values like...

Time before VC Time after VC

8 5

6 4

Total 14 9

Thanks

Bhupal

Re: How to get the Count Expression for Total available number?

simenkg — Wed, 10 Dec 2014 08:52:52 GMT

Create a new thread for this question and I'm sure you will get help quickly.

When you do, elaborate on your problem. It is not clear to me where you get 9(5*9) from.