Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Beginners Tasks Series - Task1

kkkumar82
Valued Contributor III

Beginners Tasks Series - Task1

All,

I would like to add a task series for Qlik beginners based on the real time senarios.

As part of this I am starting this series .

This first task is all about dates.

Scenario:

Consider their is a set of transnational data which includes Amount . Now I want to analyze the amount based on the dates selected like

From and To , the visualizations should shows the sum(Amount) in between these dates.

Concepts Used here:

Set analysis with out getfieldselections() for alternate states

Set analysis with getfieldselections() for alternate states

Alternate States

Sheet Object Used:

Text Boxes

List boxes

Input Boxes

Table Boxes

Front end Variables

The attached qvw will show different ways to do it.

-> Using Hard coding

-> Using Input boxes

-> Using List boxes

-> Also can be done using Sliders(but this is not a good visualization, I omitted it)

Hope it helps the beginners searching for scenario based learning.

Thanks

Kiran Kumar

Labels (1)
Attachments
Comments
chooco_co
Valued Contributor

Hi Kiran,

Thanks for your idea.

if i'm allow to add a little, on the Solution Page 2, you can using this :

=Sum({<Date ={">=$(=min({State1}Date))<=$(=max({State2}Date))"}>} Amount)

Regards

Marco

kkkumar82
Valued Contributor III

Hi Marco,

Really appreciate your idea I will add to the existing a release a new one.

Thanks

Kiran Kumar

kkkumar82
Valued Contributor III

Hi Marco,

Please find the change in the solution page 2 , I have created a new text box with your suggested expression.

Thanks

Kiran Kumar

psankepalli
Contributor III

HI Kiran,

I like your concept.. go head.. appreciate your efforts.

Thanks

KR

prma7799
Honored Contributor III

Hi Kiran,

Really appreciate your idea , but am unable to open the file.


Thanks

kkkumar82
Valued Contributor III

Hi ,

Whats the problem your are getting, are you having a licensed version of Qlikview , let me know

Regards

Kiran Kumar

prma7799
Honored Contributor III

Hi Kiran,

Thanks for your reply.. Now it is working fine.

Thanks

chaitrang
New Contributor II

Hi Kiran,

Nice Post,Very Helpful for beginners.

Version history
Revision #:
1 of 1
Last update:
‎03-31-2016 09:47 AM
Updated by: