Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Karl_Hart
Contributor

Re: Set Analysis Date Variable

Perfect, thank you very much. I initially though of using firstsortedvalue but can never get the expression right

Thanks

MVP
MVP

Re: Set Analysis Date Variable

Great that my solution served the purpose.

If you want to learn more about Set Analysis you can check my Udemy course on Set Analysis.

Become an Expert of Qlik Set Analysis

YoussefBelloum
Esteemed Contributor

Re: Set Analysis Date Variable

Hi,

can you please share your opinion to this: (praveen's working solution) compared to yours ? pro and cons

max({<IndexDate = {'<$(=Date(vDateFrom))'} >}Sales)



Highlighted
MVP
MVP

Re: Set Analysis Date Variable

Say we have one more line in our data.

Means for same Company,Product and Date, we have two lines of sales.

02/01/2017, XYZ Ltd, Product 1 ,8000

In that case, Praveen's solution will give 8000, which is Max.

My solution will give 15,000 (i.e. 7000+8000).

Now, it's depends on what end user wants... Total Sales or Max Sales.

Hope this will make clear idea what I mean to say..!!

YoussefBelloum
Esteemed Contributor

Re: Set Analysis Date Variable

Thank you so much