Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

row number for id and date and then if condition but not in script

Hello All,

First i need to this on front end only not in edit script because we having a big data model and every field is coming from some different table and it is totally confussing. so better to do in dashboard only.

i am already having the chart which actually show no. of shopping basket in range of amount.

for example if one customer shop with us  4 times on  different dates then provide them a filter to select orders=<3 or orders >3.

Customer id, Date, order, Amount, Filter

20001, 04.11.2016, 51000, 32,  3

20001, 10.10.2016, 51001, 43,  2

20001, 09.09.2016, 51045, 80, 1

20001, 14.11.2016, 49900, 21,  4

20022, 13.11.2916, 51006, 37,  3

20022, 02.10.2016, 51002, 81, 2

20022, 09.11.2016, 49903, 44, 1

20122, 04.11.2016, 49777, 55,  3

20122, 10.10.2016, 51050, 66,  2

20122, 09.09.2016, 52011, 43,  1

20122, 16.11.2016, 52044, 22,  5

20122, 13.11.2916, 51007, 93,  4

here in above sample 20001 customer order 4 times then will have some filter which can filter out the same chart only for those customer who shop just 3 times. and one another chart for those cutomer who shop with us more than 3 times. than this 20001 will be incuding in =<3 chart also  and also in >3 chart but 20022 customer shop with us only 3 times than his data only including in =<3 filter.

I hope i am able to expalin the problem. Filter is one extra filed which i create just to explain the problem.

  I am attaching sample qvw file.

Really don't know how to find the solution. may be row id, aggr, rank any of these or some other function can help.

4 Replies
Anonymous
Not applicable
Author

let me know if i understand you

you like only appear in the graphics the client with 3  buys?

sunny_talwar

Are you looking for a filter where you have two options <= 3 and > 3? or are you looking for two charts where one include just those customers who have <=3 orders and one which include all orders?

Not applicable
Author

Yes, I am looking for filter where i have two option <=3 and >3.

and this filter, i need for chart to show two different view of chart on selection of filter(<=3 and >3) and one with all data which i have already with me.

OR

Three fixed chart(witjhout filter as selction).

1. which i already have with all data.

2. <=3 order data (on earliest 3 dates for customer)

3. >3 order data (on latest dates)

Not applicable
Author

I am looking for filter where i have two option <=3 and >3.

and this filter, i need for chart to show two different view of chart on selection of filter(<=3 and >3) and one with all data which i have already with me(without any filter selection).

OR

Three fixed chart(without filter as selction).

1. chart which i already have with all data.

2. chart <=3 order data (on earliest 3 dates for customer)

3. chart >3 order data (on latest dates)