Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deepaksingh
New Contributor

Multiply by selected Day bucket

Please suggest how can I calculate Sum of QTY_VAL and multiply by selected day bucket .

7 Replies

Re: Multiply by selected Day bucket

sum(QTY_VAL) * [day bucket]

deepaksingh
New Contributor

Re: Multiply by selected Day bucket

How to create day bucket, which will count days only for selection, like if i select 5 days in calendar then bucket should be for 5 days, if i change selection then days count will change

DavidŠtorek
Contributor III

Re: Multiply by selected Day bucket

Hi,

Try something like this

Count( distinct DATE)

MVP
MVP

Re: Multiply by selected Day bucket

You may be better off creating and uploading a small sample QVF app file to illustrate your requirement and ensure accurate and relevant help. It does not need to be real data, but it should reflect the fields and tables of the real app and include the table you want and exactly what results you would lie to see.

jyothish8807
Honored Contributor II

Re: Multiply by selected Day bucket

Hi Deepak,

Try this sample:

Br,

KC

Best Regards,
KC
deepaksingh
New Contributor

Re: Multiply by selected Day bucket

There is no sample mentioned

jyothish8807
Honored Contributor II

Re: Multiply by selected Day bucket

Hi ,

I have attached a qvf file.

You can try this exp also:

if(GetSelectedCount(Date)=0,Sum(Sale),

Sum(Sale)*GetSelectedCount(Date)

)

Br,

KC

Best Regards,
KC