topic Re: Manipulating with columns in Qlik sense in App Development

Manipulating with columns in Qlik sense

jasmina_karcic — Sat, 16 Nov 2024 05:26:12 GMT

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

Re: Manipulating with columns in Qlik sense

Brett_Bleess — Mon, 29 Jul 2019 19:10:15 GMT

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

Re: Manipulating with columns in Qlik sense

mahaveerbiraj — Tue, 30 Jul 2019 13:45:59 GMT

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 .

Re: Manipulating with columns in Qlik sense

jasmina_karcic — Wed, 31 Jul 2019 07:44:31 GMT

Guys, thank you.

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

🙂