Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
DS14
Partner - Contributor III
Partner - Contributor III

Multiply by selected Day bucket

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

7 Replies
Gysbert_Wassenaar

sum(QTY_VAL) * [day bucket]


talk is cheap, supply exceeds demand
DS14
Partner - Contributor III
Partner - Contributor III
Author

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
Creator III
Creator III

Hi,

Try something like this

Count( distinct DATE)

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jyothish8807
Master II
Master II

Hi Deepak,

Try this sample:

Br,

KC

Best Regards,
KC
DS14
Partner - Contributor III
Partner - Contributor III
Author

There is no sample mentioned

jyothish8807
Master II
Master II

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