Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please Try:
Script:
IF(Len(Trim(Sales)) = 0 ,0, 1) as Flag
UI:
Count({<flag ={'1'}, year ={2010,2011}>}Customers)
Can you please share a sample data?
if(sales > 0 ,1, 0) as Flag
thanks for Response,
but how to create a flags. and how to use them .
only({<flag ={'1'}, year ={2010}>}customers)
Count({<flag ={'1'}, year ={2010}>}customers)
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.
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.
Sunny am attached my sample Qvd. in new Thread.
Hi,
Please Try:
Script:
IF(Len(Trim(Sales)) = 0 ,0, 1) as Flag
UI:
Count({<flag ={'1'}, year ={2010,2011}>}Customers)