Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Nancy_Jain
Partner - Contributor II
Partner - Contributor II

Alternate States on straight table

Goal - I  have straight table in which I want that each columns shoes count of selected date , selection is made from listbox I of  dates 

Suppose If I select 4 dates from list box then in case I get 3 columns which should show count of products on that particular date.

 

It's client data so cannot share QVW

Thanks for help in advance

Need help urgently

3 Replies
Anil_Babu_Samineni

Your question is not related to the Alternate states. But title looks like "Alternate States".

Anyway, Can you explain sample data set? Because, we never ask to share your client data with public.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Gysbert_Wassenaar

" I select 4 dates from list box then in case I get 3 columns "
Interesting. How is the selection of 4 dates related to the three columns?

Can you create a small example qvw with some dummy data that explains what you're trying to achieve?

talk is cheap, supply exceeds demand
madimadi
Contributor II
Contributor II

take a pivot Table. 

Dimension is your Product
second Dimension is your Date field

Expression: count( product)

then press finish and drag the date field to the right upper corner of the table, so the blue line is horizontal.

hope that helps 😉