Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis

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?



5 Replies
Anil_Babu_Samineni

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pathiqvd
Creator III
Creator III

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.

Not applicable
Author

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 ?

HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
rohit214
Creator III
Creator III

hi

You can try with

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

Regards,

Rohit