Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to ignore more selections: visitorYear, visitorMonth, visitorWeek, visitorDate
Does it work correct?
Count(DISTINCT{<products= {"=Avg(sales)>=4 AND Avg(sales)<8"},visitorYear =, visitorMonth =, visitorWeek =, visitorDate=>} products)
All selections for visitors data will be ignored?
For example, i don´t get the count of products for shopUSA in the sales chart if i select a visitor date where no visitors for the shopUSA.
BUT i ignore the selection in visitorMonth in the sales Chart. Why i don´t get the the count of products in the sales chart?
regards,
Fritz
May be try this:
Count(DISTINCT{<products= {"=Avg({<visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>}sales)>=4 AND Avg({<visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>}sales)<8"}, visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>} products)
May be try this:
Count(DISTINCT{<products= {"=Avg({<visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>}sales)>=4 AND Avg({<visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>}sales)<8"}, visitorYear =, visitorMonth =, visitorWeek=, visitorDate=>} products)
Sunny, you are my Qlik Sense hero 😉 It works, thanks a lot!
Can i cut it by a wildcard?
like:
Count(DISTINCT{<products= {"=Avg({<visitor*=>}sales)>=4 AND Avg({<visitor*=>}sales)<8"}, visitor*=>} products)
regards,
Fritz
AFAIK you cannot do that. You will have to list the fields out. One option is to create a variable and use that in place of listing all the fields out.