How to get the Count Expression for Total available number?

[Anonymous]

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

[Anonymous]

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

[#3]

Hi Kottala Bhupal,

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

Regards,

kukzzz....

[anbu1984]

=Count(Total VC)

[simenkg]

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])

[Anonymous]

Hi Aadi,

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

Thanks

Bhupal

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[simenkg]

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])