topic Re: Set analysis in QlikView

Set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi all please find the below questions and give me explanation

1) I have multiple years like 2000 to 2016. If I select year 2005 I want to display the sales from 2000 to 2005 sales.

2)If I open the document I want to display the year wise quarter wise sales how can u do?

Re: Set analysis

Anil_Babu_Samineni — Sun, 25 Dec 2016 13:59:48 GMT

First one you may write this

1) Sum({<Year = {"$(<= Max(Year))"}>}Sales)

Second one can you describe more. Year wise and Quarter wise means

2) Sum({<Year=, Quarter=>}Sales)

Re: Set analysis

pathiqvd — Mon, 26 Dec 2016 04:41:02 GMT

Hi amar,

Try This,

For First one:-

1) sum({<yearfield={"<=$(=max(yearfield))"}>}Sales)

For second one you have to create triggers in document properties(ctrl+alt+D)--> Onopen..

There you can create whatever you want to display.

Re: Set analysis

Mon, 26 Dec 2016 05:14:50 GMT

Hi Amar,

Can you explain your requirement more elaborately,

Which Chart you want to use ? Bar chart or something else.

In Query 1 : You want to show year wise sales for the selected and earlier years ?

In Query 2 : You want to show year wise as well as quarter wise (Two dimensions) for current year only by default or what when you open the document ?

Re: Set analysis

HirisH_V7 — Mon, 26 Dec 2016 05:35:06 GMT

Hi,

Check this

Sum({<Year = {">=$(= Max(Year)-5)<=$(= Max(Year))"}>}Sales)

For last 5 years based on your'e selection.

As, your'e second query tells like year and quarter,But what you want to pick i.e which year and which quarter when opening document.Can you please elaborate more.

HTH,

-Hirish

Re: Set analysis

rohit214 — Mon, 26 Dec 2016 07:09:09 GMT

You can try with

Sum({<Year = {"$(>=Min({1}Year)<= Max(Year))"}>}Sales)

Regards,

Rohit