Solved: How to get the Count Expression for Total availabl... - Page 3 - Qlik Community

Anonymous · ‎2014-12-08

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 · ‎2014-12-10

Hi Simen,

Thanks for keep posting..

i got the solution for this problem.

BR

Bhupal

Anonymous · ‎2015-01-20

Hello Simen,

I am getting some sales orders repeetedly.

Can you please suggest me how to handle the duplicate orders in the qlikview.

Reagrds

Bhupal

simenkg · ‎2015-01-20

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

Anonymous · ‎2015-01-28

Hello Simen,

I am trying to set the filter, but i am not getting exact result what i expect.

Please help me on this.

The scenario is:

sales documen Item flag

100 10 N

100 10 Y

200 20 N

300 40 N

300 40 Y

400 50 N

In the report i would like to show the values which i mentioned in the bold and underlined font.

how can i keep the expreesion on flag.

Best Regards

Bhupal

Anonymous · ‎2015-01-28

Hello All,

I am trying to set the filter, but i am not getting exact result what i expect.

Please help me on this.

The scenario is:

sales documen Item flag

100 10 N

100 10 Y

200 20 N

300 40 N

300 40 Y

400 50 N

In the report i would like to show the values which i mentioned in the bold and underlined font.

how can i keep the expreesion on flag.

Best Regards

Bhupal

How to get the Count Expression for Total available number?