topic Re: Comparing Sales values in 2 random dates in QlikView

Comparing Sales values in 2 random dates

Anonymous — Mon, 23 Jul 2018 20:11:34 GMT

Hi All,

I am seeking your help in this as i need to compare Sales between 2 different random dates selected from 2 multiboxes (drop down menu for dates) as each multibox will include all the dates available in the imported files. so there will be first multivox named as "date 1" and other multibox named as "date 2"

For example: if i want to campare sales happened in 2 random dates so i will select date 1 mulitibox as: 18 of July 2018 and in date 2 multibox i will select 26 of march 2017 (or any random date)

Thanks in advance.

Re: Comparing Sales values in 2 random dates

Anonymous — Mon, 23 Jul 2018 20:20:13 GMT

all data are in the same table, so when i chose any date from date 1 it shows the sales happened at that date, but then when i choose any date from date 2 it overides my first selection and both dates and values (sales of date 2 and sales of date 2) will be the same, so how to separate them as if they are from 2 different tables? ( given that all sales data is in the same table).

Re: Comparing Sales values in 2 random dates

maxgro — Mon, 23 Jul 2018 21:47:03 GMT

Maybe with alternate state,

an example in the attachment

Re: Comparing Sales values in 2 random dates

BalaBhaskar_Qlik — Tue, 24 Jul 2018 06:40:16 GMT

May be this one helps:

Re: How can I compare records from same dataset

Re: Comparing Sales values in 2 random dates

Anonymous — Tue, 24 Jul 2018 16:33:31 GMT

‌Thank you all, i tried using alternate state and it worked.

Thanks a lot for your help. Much appreciate.