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]

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

[Anonymous]

Hi Anbu,

I do not able to get this document.

Thanks for healping me..

Bhupal

[anbu1984]

='Available:' &Count(VC)

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

[anbu1984]

Set Nullinterpret='';

Load * Inline [

SalesDoc,VC

1,

2,aa

3,bb

4,

5,dd

6,ad

7,dd

8,dfd

9,aaa

10,adf ];

='Available:' &Count(VC)

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

[Anonymous]

Hi Simen,

I am using Inline table in this requirement...

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

Thanks

Bhupal

[simenkg · Accepted solution]

Table:

Load *,

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

inline [

Sales Document, VC

1, YES

2, NO

3, YES

4, YES

5, NO

];

[Anonymous]

Hi All,

I got the solution..

Thank you very much for healping me..

Best Regards

Bhupal

[Anonymous]

Hi Simen,

I got the solution.

Thanks for healping me.

BR

Bhupal

[Anonymous]

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

[simenkg]

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.