Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Labels (1)
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
Partner - Champion III
Partner - Champion III

" 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 😉