Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

zahidrahim_ocp
Contributor

Single Date Data

Dear Experts,

I have a table with date wise, Item wise stock quantity. Now i want to show only one last date item wise stock quantities by default.

What should be the approach?

Regards,

Zahid Rahim

5 Replies
michielvandegoo
Valued Contributor

Re: Single Date Data

Can you elaborate a bit more on your requirement, preferably with some example data?

vinieme12
Esteemed Contributor II

Re: Single Date Data

zahidrahim_ocp
Contributor

Re: Single Date Data

I could not understand the "example for upload" so i am explaining here. Suppose we have data.

Date               Item     Stock

01-01-2017     A          3

01-01-2017     B          5

02-01-2017     A          6

02-01-2017     B          8

Now we have current stock in date 02-01-2017 so i want a graph where by default figure shows for 02-01-2017 only. Later on user can change the filter for backdated data.

Similarly when new data added the default filter should be 03-01-2017.

Hope you understand now.

Regards,

Zahid Rahim

Not applicable

Re: Single Date Data

The filters are placed in the expressions. In this case it will suffice to sum ({<DATE = {`= MAX (DATE)`}>} STOCK)

zahidrahim_ocp
Contributor

Re: Single Date Data

Thank you for the update.

Can you please explain this code as i am very much new to qlik and this coding syntax.

Community Browser