topic Re: show percent value for selected date in QlikView

show percent value for selected date

tomcatxx — Wed, 25 Nov 2020 16:16:04 GMT

Hi, there.

Help! Thank you.

I have field Product (A, B and C) and Date (many days). For example, I want to see how much is the sales proportion of A for today in a Text box. So I select a product A and a date in List box. But it dose not work with following script

=Num(Sum(Sales) / Sum({<%Date = GetFieldSelections(%Date)>} Sales), '#,#0.0%')

Further more,

If I don't select a product, it shows 'Please select a product and a date'.

=if(GetSelectedCount(%Date) = 1 and GetSelectedCount(Product) = 1 , Num(Sum(Sales) / Sum({<%Date = GetFieldSelections(%Date)>} Sales), '#,#0.0%'), 'Please select a product and a date')

Re: show percent value for selected date

lironbaram — Fri, 11 May 2018 12:27:16 GMT

if you want the proportion of product A sales today in regard to all product A sales use

sum(Sales)/Sum({<Date>}Sales)

if you want the proportion in regard to all products sales in today use

sum(Sales)/sum({<Product>}Sales)

Re: show percent value for selected date

YoussefBelloum — Fri, 11 May 2018 12:37:57 GMT

you can try this:

=Num(Sum(Sales) / Sum(total {1} Sales), '#,#0.0%')