Creation of flags

[#1]

Hi,

How to create flags in qlikview .

eg: in sales data  some customers Buy's  product. i need to create a table. that  if customer buys it shows '1' if not flag should shoes  '0'

setanalysis;

i want data of customers  who flag =1 in 2010,2011 and count

Kindly Please provide any sample application on this..Experts

[Anonymous]

Can you please share a sample data?

[priyarane]

if(sales > 0 ,1, 0) as Flag

[#4]

thanks for Response,

but how to create a flags. and how to use them .

[priyarane]

only({<flag ={'1'}, year ={2010}>}customers)

Count({<flag ={'1'}, year ={2010}>}customers)

[sunny_talwar]

I think it would be better if you can share your data because the data will dictate how the flag can be created and used. May be share few lines of data in an Excel file or may be even a qvw file with data loaded in it.

[#7]

Following the above example, once you have a flag, you can put it as a column in a pivot table and using the image feature you can put some representative icon over the column. Sorting the column in the way that you need, you will get a easy and quickly way to see what you are looking for.

[#8]

Sunny am attached my sample Qvd. in new Thread.

[Anonymous · Accepted solution]

Hi,

Please Try:

Script:

IF(Len(Trim(Sales)) = 0 ,0, 1) as Flag

UI:

Count({<flag ={'1'}, year ={2010,2011}>}Customers)