topic Re: Alternate States on straight table in QlikView

Alternate States on straight table

Nancy_Jain — Tue, 30 Jul 2019 11:14:08 GMT

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

Re: Alternate States on straight table

Anil_Babu_Samineni — Tue, 30 Jul 2019 12:21:39 GMT

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.

Re: Alternate States on straight table

Gysbert_Wassenaar — Tue, 30 Jul 2019 12:34:48 GMT

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

Re: Alternate States on straight table

madimadi — Wed, 31 Jul 2019 09:12:28 GMT

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 😉