Manipulating with columns in Qlik sense

[jasmina_karcic]

Hi guys,

I am tryning to find a solution for my challenge. But I don't know how to formulate that.

In a model of data I have one big, very big table that contains, between others, columns:

DATE, STATE

For example:

DATE                 STATE

01.01.2019       40000

31.03.2019     -300

04.04.2019      300

04.04.2019     400

27.06.2019      1000

27.06.2019       3000

28.06.2019       50000

Now in application I need to have a table, where I can compare values of these two columns, but I want have an opportunity to choose a dates.

Columns in a table:

STATE1               STATE2

I would like to make one filter pane (FIRST DATE) that contains DATE dimension, but that can control just column STATE1, and the other filter pane (SECOND DATE) taht contains DATE dimension, but thta can control just column STATE2.

So if I choose in first filter pane date 4.04.2019., and in a second filter pane 27.06.2019., table should be

STATE1               STATE2

700                       1300

I need to choose 2 different dates, but every for a specific column.

I hope I explained good.

Please for a help,

thank you

Jasmina 

[Brett_Bleess]

Try the following link, it is do the Design Blog area, and I think will be quite helpful, as there are hundreds of posts out there on how to do different things.  I think you are going to need a Master Calendar for starters here, but I am not sure about the rest of the things.  One thing that can help others help you is if you can attach what you have in the app already, so they can see the data model etc. too.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[mahaveerbiraj]

Hi Jasmica,

I would say create two inline column in the app  call FIRST DATE and SECOND DATE (which should not associate with the model) , both FIRST DATE and SECOND DATE should be in different table  

Create two variable in qliksense front end(not in script)  call,

let vFirstDate=GetfieldSelections(FIRST DATE) 

let vSecondDate=GetfieldSelections(SECOND DATE) 

 write setAnalysis for STATE1 and STATE2 column

STATE1 = sum( {<DATE ={'$(vFirstDate)'}>} STATE)  

STATE2 = sum( {<DATE ={'$(vSecondDate)'}>} STATE)  

Note : please take care about date format   

sure it will help you please feel free to reply if you are not clear .

[jasmina_karcic · Accepted solution]

Guys, thank you.

I've found a solution with the alternative states...

🙂