Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Help.

Hi,

Help me am facing syntax errore:

1)Count of Customer Who Made Sales  ie when flag =1 and count 0f flag=0

2)Total Revenue of last year in Percentage

3)Count of Dealers In Year (2010) where sales flag =1

1 Solution

Accepted Solutions
Not applicable
Author

Please find below:

Question1:

='1)Count of Customer Who Made Sales when Flag =1 : ' & Count({<Sales_Flage={1}>}Customer_Code)

='1)Count of Customer Who Made Sales when Flag =0 : ' & Count({<Sales_Flage={0}>}Customer_Code)

Question2:

='2)Total Revenue of last year in Percentage : ' & Num(sum({<Year={2010}>}Gross_Sale-Discount)/sum({<Year={2010}>}Gross_Sale),'###0.00%')


Question3:

='3)Count of Dealers In Year (2010) where sales flag =1' & Count({<Sales_Flage={1},Category={"Drealer"},Year={2010}>} DISTINCT Customer_Code)

View solution in original post

2 Replies
Not applicable
Author

Please find below:

Question1:

='1)Count of Customer Who Made Sales when Flag =1 : ' & Count({<Sales_Flage={1}>}Customer_Code)

='1)Count of Customer Who Made Sales when Flag =0 : ' & Count({<Sales_Flage={0}>}Customer_Code)

Question2:

='2)Total Revenue of last year in Percentage : ' & Num(sum({<Year={2010}>}Gross_Sale-Discount)/sum({<Year={2010}>}Gross_Sale),'###0.00%')


Question3:

='3)Count of Dealers In Year (2010) where sales flag =1' & Count({<Sales_Flage={1},Category={"Drealer"},Year={2010}>} DISTINCT Customer_Code)

maxgro
MVP
MVP

1)

count({<Sales_Flage={1},Year={$(=max(Year))}>} distinct Customer_Code)

count({<Sales_Flage={0},Year={$(=max(Year))}>} distinct Customer_Code)


or without the year filter

count({<Sales_Flage={1}>} distinct Customer_Code)

count({<Sales_Flage={0}>} distinct Customer_Code)


2)


maybe

num(

     sum({$<Year={'$(=Max(Year))'}>}  (Gross_Sale-Discount))

     / sum({$<Year={'$(=Max(Year)-1)'}>}  (Gross_Sale-Discount)) -1

, '#,##0.0%')



3)

for the count of dealer here

=count({$<[Category]={'Dealer'}>})

1.png

you need a field

=count({$<[Category]={Dealer},Year={2010}>} distinct Customer_Code)

or

count({<Category={Dealer},Year={$(=max(Year))}>} distinct Customer_Code)